Altova DiffDog 2024 Enterprise Edition

Viewing Differences Between Tables

Home Prev Top Next

Every time after you run a data comparison or a CSV 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.

Right-click an empty area in the comparison window, and select Show 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.

 

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_07

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_no-merge-L2R

Show/Hide rows that cannot be merged from left to right

Shows or hides rows that are different in the left and right component and can be merged only from the right to the left side and not from the left to the right side.

ic_no-merge-R2L

Show/Hide rows that cannot be merged from right to left

Shows or hides rows that are different in the left and right component and can be merged only from the left to the right side and not from the right to the left side.

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 (Alt+Down)

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 (Alt+Up)

Selects the previous difference as the current difference.

ic_last-stmt

Last difference (Alt+End)

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

ic_first-stmt

First difference (Alt+Home)

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

ic_copy-L2R

Copy from left to right

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

 

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

ic_copy_R2L

Copy from right to left

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

 

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

© 2017-2023 Altova GmbH