In the previous step of the tutorial, you have learned how to start a comparison and display an overview of a comparison result directly in the Data Comparison window or in the Message window. Now you will have a more detailed look on the differences between the two versions of table tblAnimalBirths that you have compared earlier in this tutorial.
If you display the comparison result overview (either by placing the mouse cursor over the comparison result icon of tblAnimalBirths in the Data Comparison window, or by expanding the relevant row in the Summary section of the Message window), you learn that
|•||two rows are different and|
|•||three rows are only on the left side|
of your comparison of tblAnimalBirths. You can inspect this comparison result more closely in the Data Comparison Result window.
To show the detailed comparison result for "tblAnimalBirths":
Do one of the following:
|•||Click the comparison result icon next to tblAnimalBirths.|
|•||Right-click tblAnimalBirths and select Show selected results from the context menu.|
|•||In the Result window, click the Show result window hyperlink for tblAnimalBirths.|
Showing all results
You can also open all comparison results in the Data Comparison Result window with a single click. At the bottom of the Message window, DatabaseSpy provides two hyperlinks, Show only results with differences and Show all results, which open the results in separate tabs of the Data Comparison Result window.
Configuring the Result view
The Data Comparison Result window provides several buttons which allow you to show or hide rows with a certain comparison result. For example, you can hide all rows that are equal on the left and right side of the comparison or show only non-equal rows but hide rows that exist only on the left side of the comparison.
To hide all equal rows in the Data Comparison Result window:
|•||Right-click into the Data Comparison Result window and deactivate the context menu option Show/Hide all equal rows.|
Only non-equal rows are displayed in the Data Comparison Result window.
In the next step, you will also hide all rows that occur only on the left side of the comparison and display only those rows that exist in both tables and are different on the left and right side.
To hide all rows that exist only on the left side:
|•||In the Data Comparison Result window, deactivate the Show/Hide rows that are only on the left button in the toolbar.|
Now only rows are displayed that exist in both tables and are different on the left and on the right side.
Since a lot of columns are now displayed where no differences occur, you can also hide these columns and restrict the display to exact those columns and rows which are different in the two tables.
To hide all columns where no differences occur:
|•||In the Data Comparison Result window, deactivate the Show/Hide columns which don't have any differences button in the toolbar.|
Only two rows and two columns are now displayed in the Data Comparison Result window – exactly those data sets where the differences occur.
© 2019 Altova GmbH