we have a home grown product developed in cobol and have schema defined as DDS. Our schema is very complex and system has been running for the past 10 years.
As part of our application migration, we are planning to create a new database with relatively simple schema. We are planning to move the data from database in old schema to new schema.All our new applications will be on new database and eventually the legacy applicaitons will be moved to new database. In this transition process, we need to sync the data between new database and old database. Any updates to the new schema has to be propagated to the old one and vice versa.
We are planning to user triggers for data sync and we are facing challenges in this arena. It is left to perform real time updates or asynchronous updates. Business does not need real time sync.
In this scenaio, how do we sycn the data between old and new databases if there are simultaneous updates ?
Do you suggest asnychronous or sync updates ?