Match tables manually

You can match your tables manually if the Vital Checks: Database to Database Wizard cannot do so automatically or if you prefer to match your tables manually.

If your databases under test are very different and you have to add a high number of matches, you can also match your tables with external mapping files.

To match you tables manually, follow the steps below:

1. In the Source Table Usage section, double-click the source table you want to match. The Vital Checks: Database to Database Wizard adds the table in a new row in the top section.

   Alternatively, you can add the table via drag and drop into the Source Table column in the top section.

2. Drag and drop the table you want to match with it from the Target Table Usage section into the same row in the Target Table column.

To undo a match, select a table and press Delete. Alternatively, you can remove the table via drag and drop. This only affects the match and has no impact on the database file.

To export your matches, click Export matches to file.

Multiple matches for one table

Tosca BI supports multiple matches. To match the same table multiple times, follow the steps below:

1. Enable the checkbox Show already matched tables in the sections Source Table Usage and Target Table Usage. The Wizard then displays all tables, including tables that were already matched.

2. Add the source and target tables manually as described above.

The Used column in the sections Source Table Usage and Target Table Usage indicates how many times an individual table was used to match another table.