Oracle to PostgreSQL Migration.

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.

 DBConvert for Oracle & PostgreSQL

Migration directions:

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

Version: 1.1.8

Release Date: May 10, 2018

 DBSync for Oracle & PostgreSQL

Sync directions:

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

Version: 1.2.1

Release Date: Nov. 5, 2019

Supported OS:

Related Links

GUI Application.

Use DBConvert / DBSync software GUI application to configure parameters for starting a migration process.

In general, the following 4 steps are required to perform conversion or synchronization

  1. Choose Source Database.
  2. Choose Destination Database.
  3. Custoimzation and configuration.
  4. Execution.

Optionally save connection settings and configuration parameters into the session file to schedule the launching of sync or migration jobs regularly.

The screenshot below sums up general features available in DBConvert software solutions.

Command line mode

Previously saved sessions can be passed as parameters to Command-Line DBConvert Client. A session keeps source/ target DB connection settings and other specified options.

Example: C:\Program Files\DBConvert\oracle2postgresqlPro\oracle2postgresqlPro_Cons.exe /Session:"Session_Name"

NOTE: First, you have to run the software in GUI mode to create a session file with initial parameters.

Built-in scheduler.

Our applications come with a built-in scheduler to run database migration and sync jobs at specified times. Just set the scheduled date and time to execute job sessions automatically.

DBConvert screenshot

Highlights

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

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

Try All-in-one DB migration and Sync software.

DBConvert Studio

 Version: 1.7.8

Release Date: June 21, 2020

Supported databases:

  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • Access
  • FoxPro
  • SQLite
  • Firebird
  • Excel
  • IBM DB2
  • MS Azure SQL
  • Amazon RDS
  • Heroku Postgres
  • Google Cloud