Oracle-PostgreSQL Sync

Using two database clients is smart, since it allows you to have a permanent backup of your data. Keeping them synchronized is a whole other story.   Done manually, database synchronization is tedious, if not impossible. That is why a dedicated database synchronization tool really comes in handy.

Oracle-PostgreSQL Sync makes it possible for you to keep your Oracle and PostgreSQL databases in sync at all times without having to export and import records. Thanks to its wizard-based interface, the application is extremely easy to use and only requires minimum configuration to get the task done. In other words, database synchronization only becomes a matter of clicking a few “Next” buttons.

One of the perks of the application is its support for bi-directional synchronization, meaning it can copy data from Oracle to PostgreSQL or viceversa. It supports all the versions of PostgreSQL, including Heroku.

The first screen enables you to choose the synchronization direction before proceeding to the wizard. You are required to provide the server connection details in the first steps of the wizard, both for Oracle and PostgreSQL. At this point, you can also provide the name of the databases you want to connect to along with the credentials.

The next step provides drop-down lists of all the available databases that you can sync. It is advisable to specify a location and a name for the log file as well, since it allows you to see what has happened in the improbable case of sync failure.

Oracle-PostgreSQL Sync can perform full synchronization at the first run or perform an incremental synchronization, meaning it deletes the rows missing in the source table.

Oracle-PostgreSQL Sync offers a solution to a task that might seem difficult: synchronizing Oracle and PostgreSQL databases. With a simple configuration, command line support and a wizard-based interface, this type of application is the way to go if you want to keep your databases in sync.