Comparing and merging data objects in the Compare editor

When you compare data objects, the Compare editor opens in the editor area. The differences between data objects are highlighted in the Compare 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.
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:
Compare With > Another Data Object
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.
Compare With > Original Source
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.
Note: Some products include the ability to filter the types of objects that are included in the comparison. You can filter the types of objects that are included in the comparison in the Filtering Criteria window, which opens when you perform a data object comparison. If you want to compare certain data objects, select those objects in the Filtering Criteria window. When you compare data objects, only the selected types of data objects are displayed. When you generate DDL to apply your changes, only the selected types of data objects and other required data objects are included in the DDL file.

The Filtering Criteria dialog uses the global preferences for data comparison as the default setting.


Feedback