Oracle to PostgreSQL Migration.

 DBConvert for Oracle & PostgreSQL

Version: 1.1.8

Release Date: May 10, 2018

Conversion directions:

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

Version: 1.2.0

Release Date: Oct. 31, 2018

Synchronization directions:

  • PostgreSQL ↔ Oracle
  • PostgreSQL ↔ Amazon RDS ↔ Oracle
  • PostgreSQL ↔ Heroku Postgres ↔ Oracle

Our DBConvert/DBSync software assists with your data conversions and synchronizations from Oracle to PostgreSQL, Amazon RDS PostgreSQL or Heroku Postgres instances. In case you have no direct connection to PostgreSQL, you can also use Dump files and PHP scripts as a target.

Several migration options are presented in the configuration step in our GUI wizard. Our powerful command line mode to automate migration tasks is available in DBConvert/DBSync for Oracle and MySQL as well.

It takes between 4-7 minutes to migrate 1 million records.

Trigger-based database replication methods and simultaneous bi-directional synchronizations help you to manage your data easy and efficiently.

Product Highlights

  • Ability to connect to PostgreSQL 8.x./ 9.x/ 10.x located on Linux, Solaris, Mac OS X, Window machines
  • Saving data into an Oracle Dump for export to Oracle database
  • Amazon RDS Oracle DB Instance support
  • Direct connection to PostgreSQL server
  • Amazon RDS PostgreSQL DB Instance support
  • Oracle 10.x.x/ 11.x.x/ 12.x.x, Oracle XE (Express Edition) located on Linux, Solaris, Mac OS X, Windows machines
  • Views conversion from Oracle to MS SQL and MySQL and back support
  • ODBC Oracle and Oracle client are not required
  • Saving data into a PostgreSQL Dump and PHP script for export to PostgreSQL database
  • Heroku Postgres as a source or target database.
  • PostgreSQL schemes support
  • Speed conversion with Bulk and Quantization features

Product Requirements

  • Oracle 12.x versions require Oracle Database 12c Release 2 Client (12.2.0.1.0) for Microsoft Windows (32-bit) to be installed:
  • 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 Oracle server (this requirement is optional as there is an option to overcome the restrictions using dump file)

Latest News

  • Heroku Postgres and Amazon RDS support added
  • Trigger-based and bi-directional data replication support