Migrate SQL Server to PostgreSQL

Shiji Pan

1 year ago

Want to migrate from SQL Server to PostgreSQL ?

Try Withdata DBCopier, a SQL Server to PostgreSQL converter for Windows, Mac, and Linux, Migrate SQL Server to PostgreSQL, Easy and Fast.

Step by Step, just a few mouse clicks.
Create PostgreSQL tables with auto mapping data types. Create PostgreSQL indexes.

Download Withdata DBCopier
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

Migrate from SQL Server to PostgreSQL

Choose source SQL Server database and logon.

Choose target PostgreSQL database and logon.

Click “Wizard – Import All Tables” at task dialog.

then show the wizard.

1. Open source SQL Server.

2. Set “Import Type”.

3. Select PostgreSQL tables to migrate.

4. Migrate from SQL Server to PostgreSQL.

Create PostgreSQL tables. Copy SQL Server data to PostgreSQL. Create PostgreSQL indexes.

FAQ

What is Withdata DBCopier?

Withdata DBCopier is an on-premise data conversion software that helps you to copy data between databases. Download Withdata DBCopier

How long does it take to migrate from SQL Server to PostgreSQL?

DBCopier works fast. It convert millions of rows within a minute.

Is it safe to migrate from SQL Server to PostgreSQL using DBCopier?

Of course! DBCopier migrate from SQL Server to PostgreSQL locally, absolutely safe.

Can I migrate from SQL Server to PostgreSQL on Linux, Mac OS?

Yes, you can. DBCopier has Linux, Mac OS, and Windows version.

More about SQL Server to PostgreSQL converter

Download Withdata DBCopier
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

SQL Server → PostgreSQL reference

Type mapping

Value kind	in SQL Server	in PostgreSQL
Int	`int`	`integer`
Decimal	`decimal(p,s)`	`numeric(p,s)`
Float	`float`	`double precision`
Text	`nvarchar(n)`	`varchar(n)`
Long text	`nvarchar(max)`	`text`
Datetime	`datetime2`	`timestamp`
Binary	`varbinary(max)`	`bytea`
Boolean	`bit`	`boolean`
JSON	`nvarchar(max)`	`jsonb`

Dialect differences

Both SQL Server and PostgreSQL are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.

Property	in SQL Server	in PostgreSQL
port	`1433`	`5432`
identifiers	`[square brackets]`	`"double quotes"`
row limit	`SELECT TOP n`	`LIMIT n`
dates	`datetime, datetime2, date, time`	`timestamp, timestamptz, date, time`
long text	`nvarchar(max)`	`TEXT`
binary	`varbinary(max)`	`BYTEA`

Command line

Side	Command
SQL Server	`bcp`
PostgreSQL	`pg_dump or COPY ... TO`
PostgreSQL (load)	`COPY ... FROM`
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.