Microsoft SQL Server to PostgreSQL Migration.

 DBConvert for MSSQL & PostgreSQL

Version: 3.5.4

Release Date: March 19, 2015

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

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa
 DBSync for MSSQL & PostgreSQL

Version: 2.8.7

Release Date: March 27, 2015

Synchronization directions:

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

Interface languages

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

Product Highlights

  • Views conversion from MS SQL to MySQL and Oracle and back support
  • PostgreSQL schemes support
  • Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
  • Speed conversion with Bulk and Quantization features
  • Amazon RDS PostgreSQL DB Instance support
  • MS SQL schemes support
  • Speed conversion with Bulk and Quantization features
  • MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
  • Amazon RDS SQL Server DB Instance support
  • Direct connection to PostgreSQL server
  • Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
  • Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database
  • Saving data into a MS SQL Dump for export to MS SQL database
  • Ability to connect to PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, Window machines

Product Requirements

  • MDAC 2.8
  • 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

  • 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.