Duplication and comparison of logical units of information

Duplication and comparison of logical units of information

The Case

Your databases are sophisticated and contain multi-level data storage. Information about any object is contained in different tables and is bound by an identifier. (For example "Personal Information" is contained in tables "Personal Details", "Sales", "Contracts", "Accounts" etc. and is bound by the identifier "Personal_ID"). You need to compare logical units of such information stored in different databases. These databases may not only be on different servers, but they may also be implemented by different vendors (for example ORACLE and SQL SERVER). In addition, tables containing this information may be structured in a different way.

The organization and realization of such a comparison is a complex and time-consuming process. It is labor-intensive, time-consuming, and prone to human error.

Main goals to be achieved

Comparison of the logical data, contained in different tables and combined logically;
Comparison of the data, contained in tables with different structure;
Reducing the time needed for comparison of logical units of information.

Our solution

Use Cross-Database Comparator Pro or Cross-Database Studio to compare logical units of information:

1. Create Virtual Tables, containing information about objects that is virtually stored in different tables of different databases;

2. Compare the contents of Virtual Tables in order to get detailed reports about the found differences;

3. The received reports are analyzed in order to make a decision about further steps. If the uncovered difference between the databases is dramatic - act to change the software product, or take any other action, in accordance with your profile;

You can assign the comparison at night, or at any other convenient time, by using the scheduling capabilities of the CDBS products.

Advantage of our solution

Speeds up the comparison of the logical units of information;
Improves the quality of data comparison;
Automated comparison procedure means no time-overhead for developers and reduction of the probability of human error.