Schema Comparison Window

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

Home >  The DatabaseSpy Interface > Editors and Comparison Windows >

Schema Comparison Window

The Schema Comparison window allows users to choose two schemas from two data sources (that may or may not be different) and display their items for the purpose of comparing the structure in these schemas. Mappings are defined either automatically by DatabaseSpy or manually by the user in this view.

xsd-window

Schema Comparison window

When you right-click in an unoccupied area of the Schema 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 items

Starts a schema comparison of the items that are currently mapped in the Schema Comparison window.

Merge selected from left to right

Show merge script: Left to Right

Generates a merge script for all different items in the schema comparison and updates the structure of the items in the right component with the structure from the items in the left component. If you start this command from the toolbar and one or more items are selected, the merge script will be generated only for the selected items.

Merge selected from right to left

Show merge script: Right to Left

Generates a merge script for all different items in the schema comparison and updates the structure of the items in the left component with the structure from the items in the right component. If you start this command from the toolbar and one or more items are selected, the merge script will be generated only for the selected items.

Open Data Comparison in new Schema Comparison

Open in new Data Comparison

Opens all tables that are included in the schema comparison in a new Data Comparison window


Sort items | Ascending

Sorts the items in the comparison component ascending.


Sort items | Descending

Sorts the items in the comparison component descending.


Sort items | Ascending mapped first

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


Sort items | Descending mapped first

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


Map items

Maps corresponding items in the Schema Comparison window.


Unmap items

Removes all mappings from the Schema Comparison window.


Expand items

Expands all items in the Schema Comparison window and shows the child objects of the items.


Collapse tables

Collapses all tables in the Schema 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