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

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

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 PostgreSQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script)
  • 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)
  • MDAC 2.8

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.