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

DBConvert/ DBSync for MSSQL and PostgreSQL cross database migration software helps to convert and synchronize your database from Microsoft SQL Server to PostgreSQL / Amazon RDS PostgreSQL / Heroku Postgres and in any other possible combination of source and target . As well, Windows Azure SQL Databases may be set up as source or target. Programs are 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 it makes transferring data not so trivial if you try to do that manually.

The whole database can be copied from a MS SQL Server database to a PostgreSQL database or you can specify partial set of data in customization stage for migration.

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


Once data is migrated, sync of all updates in the MSSQL db to the PostgreSQL db can be performed smoothly with 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 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.