- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Synchronize and migrating between 2 different databases
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.