Viewing the structural differences of data objects in the Compare editor

The Structural Compare view in the Compare editor shows the structural differences between data objects. You can view the structural changes from one object to another. This view is available only when you perform a comparison among data objects.

About this task

The following basic comparison actions are available in the Structural Compare view of the Compare editor when you compare data objects:
Next Difference Next Difference toolbar button icon
Navigates to the next structural difference in the data object source or target.
Previous Difference Previous Difference toolbar button icon
Navigates to the previous structural difference in the data object source or target.
Pair Pair toolbar button image
Pairs data objects in different data models that have different names.
Separate Separate toolbar button image
Removes the pairing from data objects in different data models that you have paired.

If you make changes to a model object, the changes are automatically added to the model; then you must save the model to save the changes. You can also choose not to save the changes, and generate delta DDL statements instead.

If you make changes to a server object, then you must generate delta DDL statements for the object and then deploy it to the server to save the changes.

Procedure

To view the structural differences of data objects in the Compare editor:

  1. Navigate to structural differences in the table by using the Next Difference Next Difference toolbar button icon and Previous Difference Previous Difference toolbar button icon toolbar buttons on the main toolbar. You can also navigate by clicking in the table, pressing the arrow keys on the keyboard, and pressing Enter.
  2. If you are comparing two data objects that have different names but are structurally the same, pair the data objects. In the Structural Compare view, select the data objects and click the Pair toolbar button Pair toolbar button. To remove the pairing from those data objects, select the data objects and click the Separate toolbar button Separate toolbar button image.
  3. If you want to merge the changes from one object to another, merge the data object properties in the Property Compare view.

Feedback