View Schema Comparison Results

After comparing schemas, you can review the following results in the Schema Compare window and select the objects for synchronizing .

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

Pane

Description

Objects

Displays a list of objects retrieved from the compare. Select the objects for synchronizing.

Tip: Hover mouse over Objects to see report. It displays the total number type of objects that are different, identical, available in the source schema or in the target schema only. To view a report in a printable format, select File | Print Preview.

When running multi-target compare the columns at the right of the pane show information per target. To see the object scripts click on required target column.

Review the comparison statuses:

	(Source only) Object exists on the source, but is missing on the target.
	(Target only) Object exists on the target, but is missing from the source.
	(Different) Object exists on both databases, but has differences.
	Objects are equal on both databases.
	(Multi target comparison) Object exists neither on source nor on selected target.

Targets

Displays a list of databases used as targets in multi target compare.

Properties

Displays the properties of the object selected in the Objects pane (for both source and highlighted target).

Selected Objects

Displays a list of objects, selected for synchronizing.

Source script

Displays the CREATE script for the object selected in the source schema. If an object exists in both schemas, any differences are highlighted in a side-by-side comparison. If an object exists in only the Source schema, the Target script pane is blank.

Target script

Displays the CREATE script for the object selected in the target schema. If an object exists in both schemas, any differences are highlighted in a side-by-side comparison. If an object exists in only the Target schema, the Source script pane is blank.

Note: When in multi target compare mode, the Target script pane shows the script for the target selected in the Objects pane.

Messages

Displays any warnings or error messages for the selected object's preview script, such as a list of objects to drop. See View Messages for more information.

To display this pane, click .

Tips:

To refresh the results without re-running the compare, press F5. This is useful if you previously ran a compare and think that someone else has made changes to one or both schemas.
You can filter the objects that display in the compare, if needed. You can save your filter settings as a profile.
You can view comparison results in a report format by selecting File | Print Preview or Print options. Click here to view a sample report.