Oracle-PostgreSQL Sync

Oracle-PostgreSQL Sync is a program to synchronize databases between Oracle and PostgreSQL or Heroku.

Features All versions of Linux/Unix and Windows Oracle are supported All versions of PostgreSQL are supported including Heroku Option to synchronize individual tables Bi-directional synchronization: Oracle->PostgreSQL or PostgreSQL->Oracle Support for incremental synchronization SSL connection for PostgreSQL is supported  Command line support Stores configuration into profile Quick Launch Easy-to-use wizard-style interface Full install/uninstall support The product can be customized according to customer requirements Unlimited 24/7 support service 1-year subscription for updates

Requirements

• Necessary privileges to created triggers in source database and to write into both source and destination databases
• Source and target databases must contain tables being synchronized, with equavalent structures and primary key or unique index defined. You can use Oracle-to-PostgreSQL and PostgreSQL-to-Oracle for initial migration
• Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10, Linux with WINE

Limitations

• Demo version synchronizes not more than 50 rows per table

How does it work

Oracle-PostgreSQL Sync works according the following scheme. When running synchronization for two particular databases at first time:

• the program does full synchronization for each of selected tables from source and destination databases (inserts into destination table missing rows from the source, updates existing rows and deletes from destination table all rows missing in source table)
• the program creates all necessary service objects for incremental synchronization in next run (table to store changes and triggers on insert, update and delete for each table being synchronized)

When running synchronization next time, the program processes only data being changed in each table using incremental synchronization technique mentioned above.

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.o_p) file with left mouse button. This will cause Oracle-PostgreSQL Sync wizard to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to synchronize only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.

Ordering

For online credit card purchasing select the appropriate option in the table below and click the corresponding "BUY NOW" link. To learn about alternative payment options please visit Ordering Page. Oracle-PostgreSQL Sync is covered by 30 day money-back guarantee

Oracle-PostgreSQL Sync single use license	$59	BUY NOW
Oracle-PostgreSQL Sync corporate license	$149	BUY NOW
Oracle-to-PostgreSQL tool for initial database migration	$59	BUY NOW
Two Products Bundle buy Oracle-to-PostgreSQL + Oracle-PostgreSQL Sync, save $35.40	$82.60	BUY NOW