Show merge script: Left to Right

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

Home >  User Reference > Menus > Schema Comparison Menu >

Show merge script: Left to Right

The Show merge script: Left to Right command opens a new SQL Editor window and displays an SQL change script that overwrites the table structure(s) contained in the right component with those of the mapped table(s) of the left component.

 

Please note that only selected items are included in the merge script and that child items are not automatically considered in the merge script when their parents are selected. If you want to merge both parent and children you must select all items.

 

Consider the following example: Two versions of a database are compared where one column is misspelled and the data type of that column has been changed on purpose between the two versions. If child entries would be automatically merged if a parent entry is selected for merging, you would not be able to correct the type in the column name without setting the data type back to its old setting.


© 2019 Altova GmbH