Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

any time tested tool to sync 2 oracle databases having different schemas?

849830Apr 21 2011 — edited Apr 27 2011
Hi,

I have 2 databases (one with old table schemas and the other one with refined table schemas) that are catering to 2 applications - a new app and the old app.
Gradually the old app will fade away, but till then we need to run these 2 apps together.
The requirement is to have a bidirectional sync between these 2 databases so that the 2 apps can reflect real-time data at any point in time used by different set of users.

Initially we thought of using Golden Gate but it seems that it is not meant for databases having different schemas.

Any recommendations what tool can be used in such a scenerio?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 25 2011
Added on Apr 21 2011
1 comment
285 views