data sync
615744Jan 2 2008 — edited Jan 7 2008we have a complex database schema developed sometime in mid 90's for business applications. It was a complex schema which could have been simplified.
We started a transition effort where we are planning to create new database with simple schema and relations. As part of this effort all new applications will be developed to use new schema and old applications will access old database until they are also converted to point to new database.
We are also planning to migrate the data from old database to the new one. During this effort we need to propagate the changes from new database to 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 IT to perform real time updates or asynchronous updates. Business does not need real time sync.
How do we handle bi-directional updates across old and new database. If we use sync updates, how do we handle simultaneous updates to old and new updates.
Do you suggest asynchronous or sync updates ?
Are there any tools to sync the data between databases in the above scenario?