SQL Splitter

SQL Splitter is a tiny command-line application that can extract tables from SQL files and save them separately. This way, it allows you to handle large SQL files easier by dividing them into smaller pieces. There is no special configuration required.

Installing SQL Splitter isn't necessary since you can unzip the files and run the executable. Administrative privileges aren't required either. However, make sure that .NET Framework is installed or it won't work.

In the console window, if you write the tool's name without any arguments, it shows the syntax: sqlsplitter.exe sql_filename.sql. There are no other commands available so you can simply indicate the SQL file that you wish to process. If it's in a different folder than the .exe, don't forget to mention the full path.

The total size of the SQL file is calculated and displayed in the console window. If SQL Splitter identifies tables, it shows their names as well. Once the entire task is over, it shows the "Done!" message and you can visit the executable's location to look for the extracted tables.

SQL Splitter automatically creates folders for each processed SQL file and applies the original file name to the directories. Each directory contains TXT files with each table extracted from the SQL. The names of the files are taken from the tables. Unfortunately, SQL Splitter doesn't save the extracted tables in SQL format. A workaround is to manually rename the files and apply the SQL extension instead of TXT.

If files with the same names already exist in the output folder, they will be overwritten by the program automatically, so you have to make sure you move them somewhere else or change their name.

Taking everything into account, SQL Splitter offers a simple solution for splitting large SQL files by tables into distinct TXT files. However, it doesn't have any advanced options. Also, it hasn't received updates from the developer for a very long time.