Execute Comparison

Once you provide the resources to be compared and set the necessary comparison settings, you can perform the schema comparison by clicking on the 'Compare' button at the bottom of the New Comparison dialog. DBChangeManager will perform the following steps to do the schema comparison:

Fetch the schema objects of Resource 1
Fetch the schema objects of Resource 2
Do a comprehensive schema object comparison
Collate the differences and construct the comparison result view
Display the comparison result view

Comparison Progress:

When DBChangeManager does the schema comparison it presents a progress screen (as shown below) furnishing the details about the operations completed, the current operations that are in-progress and Errors, if any that has occurred during comparison.

The progress screen would provide the following details:

Load Resource 1: Provides a real time log of all schema object types fetched from Resource 1.
Load Resource 2: Provides a real time log of all schema object types fetched from Resource 2.
Comparison status: Provides real time log of the status of comparison for schema object types present in Resource 1 and Resource 2.
Error Details: If there are any errors encountered during any of the above steps, an appropriate error message would be generated. Error messages would be displayed in Red, for immediate identification.

Stopping Comparison:

At anytime during the progress of the schema comparison you could stop it by clicking the 'Stop' button at the top.

Note: If the Stop button does not respond with a cancellation of the Comparison, refresh the page in the Browser using the browser's "Reload/Refresh" button and perform the comparison again or proceed with a New Comparison.

Once the comparison is complete, DBChangeManager would provide a comprehensive result view, which we will discuss about in the next topic.