Want to convert SQL file to TXT (“;” semicolon delimited text) file?
If you want to export SQL Server to TXT (“;” semicolon delimited text), see this page: SQL Server to TXT (“;” semicolon delimited text).
If you want to export SQLite to TXT (“;” semicolon delimited text), see this page: SQLite to TXT (“;” semicolon delimited text).
Try Withdata Data File Converter, a desktop SQL to TXT converter for Windows, MacOS, and Linux, Convert SQL to TXT, Easy 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.
- Convert files locally and privately, avoid uploading large SQL file(s) to online services.
- Support Windows, Linux, and macOS.
Convert SQL to TXT (“;” semicolon delimited text)
Choose SQL file -> Set TXT file -> Convert SQL to TXT
“Start a New Convert” for “SQL to TXT”.
Select From “File” “SQL” To “File” “TXT”.
1. Open source SQL file.
Support large SQL file ( > 4GB ).
Source SQL file’s content is like this:
2. Config target TXT (“;” semicolon delimited text) file.
3. Set rows options.
4. Convert SQL to TXT.
After converting, you can view the output TXT (“;” semicolon delimited text) file.
More about SQL to TXT converter
Download Withdata DataFileConverter
See Video: Convert SQL file to TXT (“;” semicolon delimited text) file in a few clicks
See also:
- Merge multiple SQL files into one semicolon delimited text
- Batch convert SQL files to semicolon delimited text files
SQL → Semicolon-delimited text reference
Type mapping
| Value kind | in SQL | in Semicolon-delimited text |
|---|---|---|
| Int | INT | 1234 |
| Bigint | BIGINT | 9007199254740993 |
| Decimal | DECIMAL(p,s) | 1234.56 |
| Float | DOUBLE PRECISION | 1.234e+10 |
| Text | VARCHAR(n) | quoted only when it contains a semicolon or a quote |
| Long text | TEXT / CLOB | must be quoted; line breaks inside force multi-line records |
| Date | DATE | 2026-09-18 |
| Datetime | TIMESTAMP | 2026-09-18 14:30:00 |
| Binary | BLOB / BYTEA | not representable - base64 or hex string |
| Boolean | BOOLEAN / SMALLINT | TRUE / FALSE, or 1 / 0 depending on the writer |
| JSON | JSON / TEXT | the whole JSON value quoted, with internal quotes doubled |
Dialect differences
Both SQL and Semicolon-delimited text are file formats, so what differs below is how each one chooses to represent a value.
| Property | in SQL | in Semicolon-delimited text |
|---|---|---|
| identifiers | Two competing conventions: single-quoted literals and diale... | Double quotes; a literal quote is doubled ("" ) |
| dates | Depends on the dialect: DATE literals, TO_DATE(), or plain ... | Dates often use D/M/Y or D.M.Y in European exports |
| binary | Dialect-specific: X-quoted literal, 0x hex, or decode() | Not supported |
| separator | Statement terminators (;) | Semicolon ";" |
| encoding | No declaration | Often ANSI or Latin-1 in European exports; UTF-8 needs a BOM |
| typing | Types belong to the target database, and they differ betwee... | None - every field is text |
| shape | Statements; a dump usually means CREATE TABLE plus INSERT rows | Flat table, optional header row |
| ceiling | No formal limit, but a single INSERT statement has to fit i... | No formal limit; row count bounded by memory |
Data File Converter without the manual work
For batch jobs, large files and scheduling use the Data File Converter converter — an offline desktop app for Windows, Linux and macOS. Free trial.
