Want to split large SQL file into multiple files by column value without programming?
Using Withdata software Data File Splitter, a SQL splitter for Windows, MacOS, and Linux, you can split big SQL file by column value 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
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Split large SQL file by column value
Choose source SQL file -> Set splitting SQL options -> Split SQL
Click “New Task” at “Start”.
Choose “SQL” file type.
1. Open SQL file as source.
The SQL file like this:
2. Config SQL file splitting options, split by column value.
If you want to split by object count, see this: Split SQL by object count.
3. Summary.
4. Split SQL file by column value.
View a result SQL file.
Split SQL by column value in command line
Save “Split SQL” session, then you can:
- Split SQL by column value in Windows command line.
- Split SQL by column value in Linux command line.
- Split SQL by column value in macOS command line.
Set scheduled tasks for splitting SQL by column value
You can schedule and automate this “Split SQL” task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.