This project contains scripts to read CSV and JSON files from specified directories and generate SQL INSERT statements. The generated SQL scripts are saved in a specified output directory (sql-files).

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

Script 10 Script10 will drop and recreate the TEST database, enable CLR integration for UNSAFE assemblies on that database, and will drop and recreate trusted assemblies for the Ollama Completions for ...

SQL Server 2005's Management Studio offers lots of new functionality, but you can't always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install ...

Learn some best practices for writing and testing SQL scripts that can automate your database tasks effectively and efficiently.