Functional check of data duplication processes

Functional check of data duplication processes

The Case

You create a replication of your database or some of its parts. You want to ensure that the duplication has passed successfully and that all of the data have been copied. However, the database management system provides no detail regarding the changes that occurred in the course of the duplication (copying) of the target database. Manual checks are time consuming (and in some cases, with large volumes, become impossible) and are prone to human error.

Main goals to be achieved

• to check the success and accuracy of the duplication;
• to reduce the time needed for the verification of the operational efficiency of the duplication process,  simplicity of the verification stages and elimination of human error;

Our solution

Upon completion of the duplication process use Cross-Database Studio to compare the data of the source database with the data of the target database:

1. Choose the tables for which the duplication process was executed. The Virtual Table mechanism can be used if necessary;
2. View the results of the comparison generated in the report; You can get the comparison report onto your screen or XML file;
3. If necessary, you can synchronize any data for which the duplication process failed. To do so you can use the Cross-Database Studio;

You can assign the test at night, or at any time you are comfortable with, by using the scheduling capabilities of the CDBS products.

Advantage of our solution

• A significant speed-up in the data duplication checking procedure;
• Improves the quality of the data duplication check;
• Automated checking procedure mean no time-overhead for developers and reduction of the probability of human error.