First, you need
SqlToTxt is a tool to batch extract SQL Server data to SQL files.
Using SqlToTxt you can batch extract SQL Server data to SQL files easily and fast.
More about SqlToTxt – the tool to batch extract data from SQL Server tables data to SQL files
SQL Server → SQL reference
Type mapping
| Value kind | in SQL Server | in SQL |
|---|---|---|
| Int | int | INT |
| Bigint | bigint | BIGINT |
| Decimal | decimal(p,s) | DECIMAL(p,s) |
| Float | float | DOUBLE PRECISION |
| Text | nvarchar(n) | VARCHAR(n) |
| Long text | nvarchar(max) | TEXT / CLOB |
| Date | date | DATE |
| Datetime | datetime2 | TIMESTAMP |
| Binary | varbinary(max) | BLOB / BYTEA |
| Boolean | bit | BOOLEAN / SMALLINT |
| JSON | nvarchar(max) | JSON / TEXT |
Dialect differences
SQL Server is a database server and SQL is a file format, so the gap is wider than a dialect difference - the rows below are where values and structure stop lining up.
| Property | in SQL Server | in SQL |
|---|---|---|
| port | 1433 | — |
| identifiers | [square brackets] | Two competing conventions: single-quoted literals and diale... |
| row limit | SELECT TOP n | — |
| dates | datetime, datetime2, date, time | Depends on the dialect: DATE literals, TO_DATE(), or plain ... |
| long text | nvarchar(max) | — |
| binary | varbinary(max) | Dialect-specific: X-quoted literal, 0x hex, or decode() |
| separator | — | Statement terminators (;) |
| encoding | — | No declaration |
| typing | — | Types belong to the target database, and they differ betwee... |
| shape | Tables of rows and columns | Statements; a dump usually means CREATE TABLE plus INSERT rows |
| ceiling | — | No formal limit, but a single INSERT statement has to fit i... |
Command line
| Side | Command |
|---|---|
| SQL Server | bcp |
| SQL Server (load) | bcp, or BULK INSERT |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.