For the comparison, you select data fields from one table or multiple tables arranged hierarchically after one another. To do this, create comparison tables in which you specify the data sources and data fields that you want to compare.
Regardless of the type of data source, the objects that you compare are represented as tables in this application.
You can select as many tables as you want for each system. You join the tables to one another using foreign keys (see Creating Foreign Keys). You assign foreign keys in the root table or the higher-level child table to the primary keys in the child tables. First create the root table: The first table that you create in a system automatically becomes the root table. Subsequent tables that you create become child tables. When the systems are compared, the information from the child tables are read using the foreign keys for the root table.
You have created a comparison object.
Choose
.In the context menu for the comparison table, choose
.A dialog box appears.
Specify the data source that you want to compare and select the data fields that you want in include in the comparison.
Save your entries.
The data sources and data fields that you have selected are displayed graphically.
Save your entries.
To create additional tables in the first system, in the context menu for the comparison table, choose
.To create the data fields for additional tables, repeat steps 2 to 3.
To create tables for the second system, in the context menu for the comparison table, choose
and repeat steps 2 to 7.Save your entries.
You have selected the tables and data fields that you want to compare.
Now create the foreign keys.