Duplication and comparison of logical units of information

The Case

Your databases are sophisticated and multi-level data storage containers. 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 be not only on different servers, but also implemented by different vendors (for example ORACLE and SQL SERVER). And tables containing the information may be structured in a different way.

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

Main goals to be achived

• 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 is

Use Cross-Database Comparator Pro 6.0 or Cross-Database Studio 6.0 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 take decisions about the further steps. If the found difference between the databases is dramatic – act to change the software product, or make any other actions, in accordance with your profile;

You can assign the comparison at night, or at any time you are comfortable with, 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 the data comparison;
• automated comparison procedure mean no time-overhead for developers and reduction of the probability of human error.