Compare Result View

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

Home >  The DatabaseSpy Interface > Editors and Comparison Windows > Data Comparison Window >

Compare Result View

The result of a database data comparison is displayed in the Compare Result View which also provides context menu options and toolbar buttons for merging data to the left or right side of the comparison.

Click to expand image

If the tables contain columns with different data types on the left and right sides which prevent data from being merged in one of the tables, the toolbar contains two additional icons which can be used to show or hide such columns. In the example below, the Show/Hide columns which don't have any differences option has been toggled off.

Click to expand image

The Compare Result view provides context menu options and toolbar buttons for filtering the content displayed in the Compare Result View, for navigating the differences, and for merging the differences between the two tables. The corresponding Toolbar icons are shown to the left, and keyboard shortcuts to the right of the options if they are available.

 

Icon

Command

Description


Auto Size Columns

Adjusts the column width for all columns in the result grid so as to display the content properly.

Show/Hide all equal rows

Show/Hide all equal rows

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

Show/Hide all different rows

Show/Hide all different rows

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

Show/Hide rows that are only on the left

Show/Hide rows that are only on the left

Toggles on and off the display of rows that are present in the left table only.

Show/Hide rows that are only on the right

Show/Hide rows that are only on the right

Toggles on and off the display of rows that are present in the right table only.

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

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. This button is only visible if columns with conflicting data types are compared.

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

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. This button is only visible if columns with conflicting data types are compared.

Next difference

Next difference

Selects the next difference as the current difference.

Previous difference

Previous difference

Selects the previous difference as the current difference.

Last difference

Last difference

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

First difference

First difference

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

Merge data from left to right

Merge data from left to right

Updates the selected data cell in the right table using the data contained in the data cell of the left table. Note that the change is committed to the database immediately without a change script being generated.

Merge data from right to left

Merge data from right to left

Updates the selected data cell in the left table using the data contained in the data cell of the right table. Note that the change is committed to the database immediately without a change script being generated.


Copy selected cells (Ctrl+C)

Copies the selected cells to the clipboard. You can select several individual cells by holding down the Ctrl button and clicking the desired cells or select a consecutive number of neighboring cells by clicking a cell and pressing the Shift key while clicking a second cell. The content of the cells can be pasted as tabbed text into a text editor or spreadsheet calculator.


Copy selected cells with header

Copies the selected cells as well as the corresponding headers (i.e., the column names) to the clipboard.


Hide

Hides the Compare Result view of the Data Comparison window. In order to show the Compare Result view again, select the table in one of the components and click the Show result ic_toggle-content button in the toolbar of the Data Comparison window or choose the menu option Data Comparison | Show results.

 

Additionally, the toolbar provides the following icons:

 

Icon

Command

Description

Show/Hide columns which don't have any differences

Show/Hide columns which don't have any differences

Toggles on and off the display of columns that are equal in the left and right table.

Find

Find

Opens the Find dialog box where you can search for data in the Compare Result View.

Show the Data Inspector window

Show the Data Inspector window

Displays the content of the selected cell in the Data Inspector window.

Go to table mapping

Go to table mapping

Shows the mapping of the compared tables in the Data Comparison window.

Maximize the result window

Maximize the result window

Enlarges the size of the Compare Result View to a maximum. To display the Data Comparison window again, click the Go to table mapping button.


© 2019 Altova GmbH