data sync

50 pts.
Tags:
Database
Synchronization
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 ?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following