Versions Compared

Key

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

...

Anchor
ViewIndividualSchemaCompareResults
ViewIndividualSchemaCompareResults
View Individual Schema Comparison Results

To see specific schema comparison results

  • After a job runs, in the Comparison Results table, click Show Individual Results

The Individual Comparison Results window appears.

Image Added

To browse the objects

  • Select or deselect the check boxes in the left-panel list.
  • Right-click and use the menu to select or deselect objects at the global or page levels.
  • Click the right and left arrows underneath the middle panel.
  • Enter a page number in the box underneath the middle panel.

To filter the objects

Type a search string into the Show/Hide Objects search box.

Image Added

To see a summary report

  • Click Generate Report.
    Image Added

To view the DDL between two schema comparison results

  • Click View Details.

To save individual schema comparison results data to a text file

  • Click Export to File.

To view the synchronization script and DDL between two individual objects

  1. In the Individual Comparison Results window Compared Objects pane, select an object that does not match.
    Image Added
    Script and DDL details appear in the pane below.
    Image Added
  2. In the Script tab, view the SQL that synchronizes the objects.

Anchor
CloneJob
CloneJob
Cloning a schema comparison job

...