Forum Stats

  • 3,837,853 Users
  • 2,262,302 Discussions


Synchronize and migrating between 2 different databases

Yockee Member Posts: 24 Green Ribbon


I got a request that might end up into big problem. There are 2 questions here.

I am in the beginning of migrating 2 different databases (normal DB, not spatial), from oracle 11g to Postgres 12.5

What factors are to be considered before the project begin ? Any thoughts are welcome

The Oracle 11g is the old system that want to be migrated to PG 12.5. Many apps depend on it and it has also some PL/SQL, but not that many.

To complicate things, it turns out that there are also some apps developed under the new PG database. The data in PG, somehow, also need to be replicated back to Oracle. Seems that there are some features of apps under Oracle that are not yet developed / supported in PG. Now the 2 dbs are in danger of out-of-synch.

Is there such a tool to do two way replications ( I assume its not a full replication, but more like table to table replication) ? I have never heard such a thing nor I have done some research on it.



Best Answer

  • kpatenge-Oracle
    kpatenge-Oracle Senior Principal Product Manager Spatial & Graph Berlin/DEMember Posts: 29 Employee
    edited Mar 28, 2022 3:33PM Answer ✓

    Hi Yockee,

    GoldenGate is the recommended tool for real-time DB migration and synchronization. Hence it applies to your "normal database". It is very flexible in terms of configuring what you want to sync and/or migrate.

    You can also write your own sync interface using REST.