Starting a Comparison

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Tutorials > "ZooDB" Database > Comparing Database Data >

Starting a Comparison

You can start a comparison from the Data Comparison menu or by clicking the Start Comparison ic_start-db-comparison button in the toolbar of the Data Comparison window. This way, you run a comparison for all mapped tables in the database comparison components. DatabaseSpy displays the row count for the compared tables and shows comparison result icons that indicate whether a pair of mapped tables is equal or contains differences. Place your mouse cursor over a comparison result icon to display a brief summary of the comparison result.

diff-tables-compared

 

To compare all mapped tables:

Select the menu option Data Comparison | Compare tables.
Click the Start Comparison ic_start-db-comparison button in the toolbar of the Data Comparison window.
Right-click the title bar in either comparison component and choose Compare tables from the context menu.

 

 

To show a brief comparison result for "tblMedicalTreatments":

Place the mouse cursor over the comparison result icon ic_diffs of table tblMedicalTreatments. A balloon help appears with an overview of the comparison result (see screenshot above).

 

Results in the Message window

The Message window below the Data Comparison window logs for which tables a comparison has been started and displays brief summaries of the individual comparison results. The message window also provides hyperlinks to the tables in the Data Comparison windows and to the detailed results of a specific comparison in the Comparison result window.

diff_results


© 2019 Altova GmbH