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) in 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 achived

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

Our solution is

Upon completion of the duplication process use Cross-Database Studio 6.0 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 6.0;

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.