Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When you select a schema object, all objects of that type are listed in the Objects area. These objects are by default selected for comparison. The objects in the left pane are the source schema and on the right are the target schema. You can filter objects using the Search text box. You can also use different toolbar actions to select or clear objects from schema compare and synchronization. This table lists these actions.

IconActions
To check all selected schema objects.
To clear the selected schema objects.
To invert the last selection.

You can also select objects by using these right-click actions.

Right-Click ActionDescription
Image Modified Check Selected
Checks all selected schema objects.
Image Modified Uncheck Selected
Clears the selected schema objects.
Image Modified Reverse Selected
Inverts the last selection.
Show All (Clear Filter)

Displays all objects by removing the search filter applied to the objects.

This action applies to Objects area.

Check AllSelects all schema objects.
Uncheck AllClears all selected schema objects.
Select AllHighlights all the listed schemas and its object names.
Invert SelectionInverts the list of selected schema objects.

Schema Options

Schema options define and alter the comparison script based on your selection. 

...

This option functions differently for both the schema compare and schema synchronization tools. The following table explains this difference.  

Schema Synchronization ToolSchema Compare Tool

In the schema synchronization tool, this option is selected and read-only. During schema compare, it extracts dependencies of the selected schema objects. These dependent objects from the selected source and target objects can be viewed in the default viewer of the Review Dependencies tab.

Image Modified

In the schema compare tool, this check box is always unselected and in the read-only mode.


Image Modified

Include Object Permissions

...

Schema Synchronization uses the quote identifier set in Script Options for schema object names when it generates the deployment script.

...

We recommend selecting and unselecting these options for schema synchronization. 

Compare Options
  • Select Include Table Constraints.
  • Select Include Table Constraints Names.
  • Select Include Comments.
  • Unselect Include Full Table (Indexes, Triggers).
Script Options
  • Select quote identifier according to the database.
Script Ignore Policies