Data Comparison Window

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

Home >  The DatabaseSpy Interface > Editors and Comparison Windows >

Data Comparison Window

The Data Comparison window allows users to select and display tables from two data sources (that may or may not be different) for the purposes of comparing the data in these tables. Mappings are defined either automatically by DatabaseSpy or manually by the user in this view. Mapping of tables can be fine-tuned to include a subset of the table's columns. Note that you need an active connection to a data source to be able to display a Data Comparison window.

app_datadiff

Data Comparison window

When you right-click in an unoccupied area of the Data Comparison window, several options are available in the context menu which are listed below. The corresponding Toolbar icons are shown to the left of the options if they are available.

 

Icon

Command

Description

Start Comparison

Compare tables

Starts a data comparison of the tables that are currently mapped in the Data Comparison window.

Merge selected from left to right

Merge Left to Right

Merges the mapped tables so that the table on the right side is updated with the data of the table on the left side of the comparison. If you start this command from the toolbar and one or more tables are selected, only the selected tables will be merged.

Merge selected from right to left

Merge Right to Left

Merges the mapped tables so that the table on the left side is updated with the data of the table on the right side of the comparison. If you start this command from the toolbar and one or more tables are selected, only the selected tables will be merged.

Show result

Show results

Shows the result of the data comparison in a new tab of the Comparison Result View (if the data has not been compared yet) or displays the corresponding result tab (if the data has already been compared before).

Open Data Comparison in new Schema Comparison

Open in new Schema Comparison

Opens all tables that are included in the data comparison in a new Schema Comparison window.


SQL and Data | Show merge script: Left to Right

Generates a merge script for all different tables in the data comparison and updates the table in the right component with the data from the table in the left component.


SQL and Data | Show merge script: Right to Left

Generates a merge script for all different tables in the data comparison and updates the table in the left component with the data from the table in the right component.


SQL and Data | Show restore script: Left

Generates a script for the left side of the comparison that restores the data to the values that were stored in the database before the merge. Note that the restore script must be generated before the merge script is executed!


SQL and Data | Show restore script: Right

Generates a script for the right side of the comparison that restores the data to the values that were stored in the database before the merge. Note that the restore script must be generated before the merge script is executed!


Sort tables | Ascending

Sorts the tables in the comparison component ascending.


Sort tables | Descending

Sorts the tables in the comparison component descending.


Sort tables | Ascending mapped first

Sorts the tables in the comparison component ascending and displays mapped tables on top.


Sort tables | Descending mapped first

Sorts the tables in the comparison component descending and displays mapped tables on top.


Map items

Maps corresponding tables in the Data Comparison window.


Unmap items

Removes all mappings from the Data Comparison window.


Expand tables

Expands all tables in the Data Comparison window and shows the table columns.


Collapse tables

Collapses all tables in the Data Comparison window.

Autolayout

Autolayout

Optimizes the component size and tries to display as much of the two components as possible in the comparison window.

 

In addition, the toolbar provides the following icons:

 

Icon

Command

Description

Stop Comparison

Stop Comparison

Stops the currently running comparison process. This button is only visible while a comparison is running.

Toggle Message Window

Toggle Message Window

Toggles the Message window on and off.

Show Options

Show Options

Opens the Data Compare page of the Options dialog box.


© 2019 Altova GmbH