#sql-script

I have created a simple #CSharp console application as a tool to split big #SQL scripts. For example, I had a problem with data seed scripts.

I have created a simple C# console application a split SQL script tool to split big scripts. For example, I had a problem with data seed scripts. Those scripts are huge because the database has more than a million records. These records need to be added to a new database. Each script is roughly 400Mb and I can’t upload it in the repository in Azure DevOps for example. Example of big SQL to…

SET @entityid (product_id) in line no. 1

SET @entity_id = 1; SELECT ea.attribute_code, ea.attribute_id, eav.value AS 'value', 'varchar' AS 'type' FROM catalog_product_entity e JOIN catalog_product_entity_varchar eav ON e.entity_id = eav.entity_id JOIN eav_attribute ea ON eav.attribute_id = ea.attribute_id WHERE e.entity_id = @entityid UNION SELECT ea.attribute_code, ea.attribute_id, eav.value AS…