Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Synchronize and migrating between 2 different databases
Hi,
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.
thanks
Best 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.
Answers
-
Hi,
Did you know that all spatial capabilities of the Oracle Database are fully included in each edition of the Oracle DB without needing any further licensing? So if there is a licensing concern leading to the migration activities from Oracle DB to Postgres, you might rethink it.
Regarding synchronizing back and forth between the two databases, please have a look at Oracle GoldenGate (https://docs.oracle.com/en/middleware/goldengate/core/21.3/gghdb/using-oracle-goldengate-postgresql.html).
-
Hi. Thanks.
I am migrating normal database, not spatial. Is there anything that i should consider ? Is there any tool to synch partially (just some tables not the whole database) ?
thanks
-
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.