Split a large SQL file into separate files for each table at one time

Want to split a large SQL file into separate files for each table at one time?

Maybe you have some huge SQL scripts files, like MySQL .sql dump file, or SQL Server .sql buckup file, or .sql from Oracle, DB2, PostgreSQL, you want to split them to small SQL files.

Using DataFileConverter, a native GUI tool, you can split a large SQL file into separate files for each table easily and fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Split SQL locally, Avoid uploading LARGE SQL file(s) to online services.
• Support Windows, Linux, macOS.

Download DataFileConverter

Split a large SQL file into separate files for each table

Choose source SQL file -> Set target SQL files -> Split SQL

Click “Start a New Convert” at task dialog.

then show the wizard.

Select From “File” “SQL” To “Files” “SQL”.

1. Open a source SQL file, select tables to split to smaller SQL files.

2. Config target target SQL files.

3. Summary.

List selected tables.

 

4. Split a large SQL file into separate files for selected tables.

After converting, you can view output SQL files.

Split SQL by table in command line

Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.

Set scheduled tasks for splitting SQL by table

You can schedule and automate this SQL splitting task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

---

More about DataFileConverter – SQL table splitter

• 
• 
•