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.
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.