Microsoft SQL Server to PostgreSQL Migration.

 DBConvert for MSSQL & PostgreSQL

Version: 3.5.8

Release Date: June 9, 2016

Conversion directions:

  • MS SQL Server → PostgreSQL, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL → MS SQL Server, MS SQL Dump, PostgreSQL Dump, PHP Script
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL
 DBSync for MSSQL & PostgreSQL

Version: 2.9.0

Release Date: Sept. 12, 2016

Synchronization directions:

  • MS SQL Server ↔ PostgreSQL
  • PostgreSQL ↔ SQL Azure
  • MS SQL Server ↔ Amazon RDS ↔ PostgreSQL
  • MS SQL Server ↔ Heroku Postgres ↔ PostgreSQL

Our DBConvert/DBSync for MSSQL and PostgreSQL cross database migration software helps you to convert and synchronize your databases from Microsoft SQL Server to PostgreSQL / Amazon RDS PostgreSQL / Heroku Postgres and in any other possible combination of source and target . Also, Windows Azure SQL Databases may be set up as a source or target. Our program is able to connect to any local or remote MS SQL Server and PostgreSQL instances.

Although both MS SQL Server and PostgreSQL databases are ANSI-SQL compliant, there are still differences between their SQL syntax, data types, case sensitivity, and these differences often makes transferring data not so trivial if you try to do that manually.

The entire database can be copied from a MS SQL Server instance to a PostgreSQL instance or you can specify partial datasets in a customization stage for each migration.

Using Dump files and PHP load scripts as a destination would be alternative if there is no direct access to servers.


Once data is migrated, all updates can be synchronized from the MSSQL database to the PostgreSQL database can be performed smoothly with our DBSync for MSSQL and PostgreSQL.

Your database will always be up-to-date due to three sync types (Drop, Insert, Update).

Run the program at user-specified time intervals specifying settings at the scheduling stage. Scheduler runs automatically and unattended in the background.

Product Highlights

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • Necessary privileges to write into database on the target PostgreSQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)

Latest News

  • Amazon RDS PostgreSQL / Heroku Postgres instances support
  • Parameterized queries implemented. Synchronization/conversion speed increased approximately by 15%.
  • Conversion/Synchronization for SQL Azure added.
  • Conversion/Synchronization speed improvement for large databases. 1 Million of records can be converted/ synchronized in 9 min from PostgreSQL to MS SQL and in 6 min from MSSQL Server to PostgreSQL.
  • Compatibility with PostgreSQL server v.8.3.1 added.
  • SSL technique for encrypted data conversion support.
  • Variable quantization step added.