Showing the Results

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

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

Showing the Results

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.

result_comparison

 

To show the detailed comparison result for "tblAnimalBirths":

Do one of the following:

Click the comparison result icon ic_diffs next to tblAnimalBirths.

diff_show-result-icon

Right-click tblAnimalBirths and select Show selected results from the context menu.

diff_show-result-context

In the Result window, click the Show result window hyperlink for tblAnimalBirths.

result_show-result

 

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.

result_show-only-diff-context

Only non-equal rows are displayed in the Data Comparison Result window.

result_show-only-non-equal

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 ic_show-hide-left-rows-only button in the toolbar.

result_hide-left-only

Now only rows are displayed that exist in both tables and are different on the left and on the right side.

result_show-only-diff

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 ic_show-hide-nodiff button in the toolbar.

result_hide-equal-cols

Only two rows and two columns are now displayed in the Data Comparison Result window – exactly those data sets where the differences occur.

result_diffs-only


© 2019 Altova GmbH