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

Product Highlights

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

Interface languages

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

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.