You can start a comparison from the Data Comparison menu or by clicking the Start 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.
To compare all mapped tables:
|•||Select the menu option Data Comparison | Compare tables.|
|•||Click the Start 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.|
|•||Place the mouse cursor over the comparison result icon 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.
© 2019 Altova GmbH