Displaying Differences in Databases

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

Home >  Comparing Database Data >

Displaying Differences in Databases

Every time after you run a data comparison (see Running a Database Data Comparison), the high-level results are displayed directly in the Data Comparison window. Namely, the result of a comparison is indicated by the following icons:

 

ic_equal

The compared objects are equal in both components

ic_different

Differences exist between the objects in the left and right components

 

Objects that are different are highlighted with green color. A balloon tip with additional information appears if you move the mouse cursor over a comparison icon.

dbdiff_compare_data_06

To view a more detailed comparison result, do one of the following:

 

Click the comparison result icon ic_diffs for a given table.
Right-click a table where differences exist, and select Show selected results from the context menu.

 

This opens a grid where differences between each column are displayed side-by-side, called the "Comparison Result View", as further described below.

 

Note:If a dialog box appears with the following text: "Data is equal, do you want to open content?", this indicates that the command above was run for a selection of tables where there are no differences.

 

The comparison outcome is also displayed in the Messages window.

dbdiff_compare_data_05

From here, you can further explore the comparison results, as follows:

 

To view differences between two tables only, click Show result window.
To view only different table pairs, click Show only results with differences.
To view all table pairs side by side (regardless of whether they have differences or not), click Show all results. Note that a new tab is created for each table pair, so it's not recommended to click Show all results if your database has a large number of tables.

 

Comparison Result View

This view displays differences between a given table pair. As illustrated below, each column is displayed twice (as it stands in the "left" table as opposed to the "right" table). In the example below, the column quantity was changed in two occurrences; also, a new row (id = 11) exists only in the "right" table.

dbdiff_compare_data_08

Use the toolbar buttons to customize which rows should be displayed in this view, or to navigate differences.

 

Icon

Command

Description

ic_show-equal

Show/Hide all equal rows

Shows or hides rows that are equal in the left and right component.

ic_show-different

Show/Hide all different rows

Shows or hides rows that are different in the left and right component.

ic_show-hide-left-rows-only

Show/Hide rows that are only on the left

Shows or hides rows that exist only in the table that is contained in the left component.

ic_show-hide-right-rows-only

Show/Hide rows that are only on the right

Shows or hides rows that exist only in the table that is contained in the right component.

ic_show-hide-nodiff

Show/Hide columns which don't have any differences

Shows or hides columns where no differences exist.

ic_next-stmt

Next difference

Selects the next difference as the current difference. If this command is disabled, click any difference on the grid first.

ic_previous-stmt

Previous difference

Selects the previous difference as the current difference.

ic_last-stmt

Last difference

Selects the last difference in the document as the current difference.

ic_first-stmt

First difference

Selects the first difference in the document as the current difference.

ic_merge-selected-left2right

Merge data from left to right

Displays a dialog box where you can merge differences from the left to the right database, see also Merging Database Differences.

 

If this command is disabled, click any difference on the grid first.

ic_merge-selected-right2left

Merge data from right to left

Displays a dialog box where you can merge differences from the right to the left database.

ic_find-diff

Find

Searches for a particular string in the Comparison Result View.

ic_show-data-inspector

Show the Data Inspector window

Opens a Data Inspector window where you can view the full content of a data cell.

ic_goto-statment

Go to table mapping

Displays the Data Comparison window (this it typically necessary after you clicked the Maximize ic_maximize-diff button).

ic_maximize-diff

Maximize the result view

Maximizes the size of the grid so as to show as many rows of the comparison as possible.

 

It is possible to customize the appearance of the Comparison Result View, see Database Data Comparison Options.


© 2019 Altova GmbH