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?