Setting Up a Database Schema Comparison

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

Home >  Tutorials > "ZooDB" Database > Comparing Database Schemas >

Setting Up a Database Schema Comparison

DatabaseSpy provides a Schema Comparison window which is used to select schemas and tables, and to map database items, start a comparison, and display the merge script for the compared items. Opening a Schema Comparison window and selecting the schemas and database items to be compared is usually done in a single step.

 

 

To select schemas for comparison:

1.Click the Schema Comparison ic_schema-compare button in the Standard toolbar or select the menu option File | New | Schema Comparison. A new Schema Comparison window is opened and the Select Database Objects for Comparison dialog box appears, where the first data source connection, ZooDBConnect, is preselected in the Data Source drop-down list, and the Left Side button is activated by default.
2.Expand the tree structure in the selection dialog box until the schemas are displayed, expand schema dbo and activate the User Tables check box. This selects all tables in the User Tables folder.

dlg_select-tables-left

3.Click the Right Side button, expand schema test and also activate the User Tables check box.

dlg_select-schema-right

4.Click OK. The tables appear in two separate components of the Schema Comparison window, and matching items are mapped automatically.
5.Select the menu option Schema Comparison | Collapse items or select this command from the context menu that opens when you right-click the header of either component in the Schema Comparison window.

diffs_mapping-unsorted

6.Optionally, if the sort order is different in the left and right component, select the menu option Schema Comparison | Sort items | Ascending or select this command from the context menu that opens when you right-click the header of either component in the Schema Comparison window.

© 2019 Altova GmbH