Split large SQL file into multiple files

by

Posted on by

Want to split large SQL file into multiple files by object count without programming?

Using Withdata software Data File Splitter, a SQL splitter for Windows, MacOS, and Linux, you can split big SQL file into multiple files 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 file locally, Avoid uploading LARGE SQL file(s) to online services.

Download DataFileSplitter Download DataFileSplitter

Split large SQL file into multiple files

Choose source SQL file -> Set splitting SQL options -> Split SQL

Click “New Task” at “Start”.

Split big SQL file into multiple files - new task

Choose “SQL” file type.

Split big SQL file into multiple files - select file type

1. Open SQL file as source.

Split big SQL file into multiple files - open source SQL file

The SQL file like this:

Split big SQL file into multiple files - view the source sql file

2. Config SQL file splitting options, split by object count.

If you want to split by column value, see this: Split SQL by column value.

Break big SQL file into multiple files - config splitting options

3. Summary.

Break big SQL file into multiple files - summary

4. Split SQL file into multiple files.

Split big SQL file into multiple files - split

View a result SQL file.

Split big SQL file into multiple files - view a result sql file

Split SQL into multiple files in command line

Save “Split SQL” session, then you can:

Set scheduled tasks for splitting SQL into multiple files

You can schedule and automate this “Split SQL” task by:

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

2) Set scheduled task.

FAQ

More about DataFileSplitter – SQL Splitter