When a comparison of data objects is performed, a comparison editor
opens in the editor area. The differences between data objects are highlighted
in the comparison editor, so that you can browse and copy changes between
the compared resources. After you copy the changes, you can generate, save,
and run delta DDL scripts to merge the changes.
The following types of data objects can be compared with each other:
- Objects
that are contained in a connection in the Database Explorer
- Physical
data models (*.ddm)
- Objects
that are contained in a physical data model
- Domain
models (*.ddm)
- Objects
that are contained in a domain model
- Logical
data models (*.ldm)
- Objects
that are contained in a logical data model
- Glossary
models (*.ndm)
When you compare data objects, the standard compare editor is customized.
For data objects, you can perform basic compare tasks, plus the following
additional tasks:
- Compares a data object with another data object. If you select this option,
a window opens so that you can select another data object for the comparison.
- Compares a data object with the original version of the object. This option
is available only if you select an object that was reverse engineered from
another data source.