PostgreSQL to Oracle Migration.

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

Our DBConvert and DBSync applications support migrations and synchronizations of databases from PostgreSQL to Oracle Server. Direct connections to source and destination are used for quick, reliable connection. Or Dump files may be set up as a target if there is no direct access to a target server. Furthermore, PostgreSQL databases may be located in Amazon RDS or Heroku clouds.

Transfer the whole database or only single elements you choose, using our migration software. Schema and view conversions can be performed easily as well.

Using an easy-to-use wizard interface, our applications guide you through all of the necessary steps needed to successfully migrate your databases. You can also configure conversions and synchronizations to your particular needs by specifying the rules for copying data to a target database. The software supports our powerful command line mode which helps users to automate data transfers.

Our DBConvert and DBSync software converts data types between PostgreSQL and Oracle automatically. But you still have an opportunity to change data types by hand with the help of our smart mapping feature.

Our built-in scheduler helps to run conversions and synchronizations automatically. Furthermore, our trigger-based database synchronizations and three sync types help you to keep your data up-to-date.

Product Highlights

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

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