Merging 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 use this view to merge structural changes from one object to another. This view is available only when you perform a comparison among data objects.
The following basic comparison actions are available in the Structural Compare view of the compare editor when you compare data objects:
Copy from Left to Right Copy from Left to Right toolbar button icon
Copies the structural attributes of the object on the left side of the editor to the object on the right side of the editor.
Copy from Right to Left Copy from Right to Left toolbar button icon
Copies the structural attributes of the object on the right side of the editor to the object on the left side of the editor.

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.

To merge the structural differences of data objects in the compare editor:

  1. Navigate to structural differences in the table by using the Go to Next Difference Go to Next Difference toolbar button icon and Go to Previous Difference Go to 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. Merge changes from one object to another:
    • To merge changes in a single row and any rows that are contained by that row, double-click the row, then click the Copy from Left to Right Copy from Left to Right toolbar button icon or Copy from Right to Left Copy from Right to Left toolbar button icon toolbar buttons on the view toolbar to merge the change. If the row you select contains other rows (for example, if you select a table that contains columns), then all of the changes in the contained objects are also merged.
    • To merge all changes, double-click in a row that is the root of the object that you are merging changes for (for example, if you are merging changes in a schema, double-click the schema row), then use the view toolbar buttons to merge all changes.
  3. Optional: Display objects that are impacted by your changes by clicking the Analyze Left Impact Analyze Left Impact toolbar icon or Analyze Right Impact Analyze Right Impact toolbar icon toolbar buttons on the view toolbar. Impacted objects are displayed in the Impacted Objects view.
  4. Save the changes:
    • To save changes to a model object, save the model, or click Generate Left Delta DDL Generate Left Delta DDL toolbar icon or Generate Right Delta DDL Generate Right Delta DDL toolbar icon to generate a DDL file that contains the changes.
    • To save changes to a server object, click Generate Left Delta DDL Generate Left Delta DDL toolbar icon or Generate Right Delta DDL Generate Right Delta DDL toolbar icon to generate a DDL file that contains the changes.
Related concepts
Comparing and merging data objects
Related tasks
Merging data object properties differences in the compare editor
Related information
Analyzing impact and dependency

Feedback