PostgreSQL Migration And Sync

PostgreSQL is a highly scalable, SQL compliant, open source object-relational database management system. Many web application developers prefer it as the back-end data management component. Its advanced feature set and key advantages such as open source community support, very low deployment cost, and easy administration make it the great choice for those who use it for database-driven web application development. Its primary competitors are MySQL, Microsoft SQL Server and Oracle DB.

The DBConvert product line covers all the most popular migration and synchronization directions, allowing users to convert and replicate data between Postgres/ Amazon RDS for PostgreSQL/ Heroku Postgres and other database engines. All PostgreSQL related migration products are listed below.

Note that two PostgreSQL/ Amazon RDS PostgreSQL DB or Heroku Postgres instances in any combination may be specified as source and target databases in our PostgreSQL related Converters and Sync tools

DBConvert Studio 

 Version: 1.0.8

Release Date: Sept. 2, 2016

Supported databases:

  • Microsoft SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Microsoft Access
  • Microsoft FoxPro
  • SQLite
  • Firebird
  • Microsoft Excel
  • IBM DB2
  • MS Azure SQL
  • Amazon RDS
  • Heroku Postgres
DBSync for Access & PostgreSQL

Version: 4.1.7

Release date: Feb. 18, 2016

Synchronization directions:

  • MS Access ↔ PostgreSQL
  • Access ↔ Amazon RDS ↔ Heroku Postgres
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
DBSync for MySQL & PostgreSQL

Version: 3.8.1

Release date: Feb. 19, 2016

Synchronization directions:

  • MySQL, MariaDB ↔ PostgreSQL
  • MySQL ↔ MariaDB
  • MySQL ↔ Amazon RDS ↔ PostgreSQL
  • MySQL, MariaDB ↔ Heroku Postgres ↔ PostgreSQL
DBSync for Oracle & PostgreSQL

Version: 1.1.8

Release date: Aug. 18, 2016

Synchronization directions:

  • PostgreSQL ↔ Oracle
  • PostgreSQL ↔ Amazon RDS ↔ Oracle
  • PostgreSQL ↔ Heroku Postgres ↔ Oracle
DBConvert for Access & PostgreSQL

Version: 4.3.3

Release date: March 16, 2016

Conversion directions:

  • Access → PostgreSQL, Dump, PHP Script
  • PostgreSQL → Access
  • Access ↔ Amazon RDS ↔ Heroku Postgres
  • MS Access queries → PostgreSQL views
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
DBConvert for MySQL & PostgreSQL

Version: 4.3.2

Release date: July 15, 2016

Conversion directions:

  • MySQL → PostgreSQL, PostgreSQL Dump, PostgreSQL PHP Script, MySQL Dump, MySQL PHP Script
  • PostgreSQL → MySQL, MySQL Dump, MySQL PHP Script, PostgreSQL Dump, PostgreSQL PHP Script
  • MySQL ↔ MariaDB
  • MySQL ↔ Amazon RDS ↔ PostgreSQL
  • MySQL ↔ Heroku Postgres ↔ PostgreSQL
DBConvert for Oracle & PostgreSQL

Version: 1.1.6

Release date: Aug. 19, 2016

Conversion directions:

  • Oracle → PostgreSQL, PostgreSQL Dump, PHP Script
  • PostgreSQL → Oracle
  • PostgreSQL ↔ Amazon RDS ↔ Oracle
  • PostgreSQL ↔ Heroku Postgres ↔ Oracle