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

Release Date: Feb. 19, 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

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

Product Requirements

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

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