How Complete Compare Works › Complete Compare

Complete Compare

Complete Compare is a powerful tool that enables you to view and resolve the differences between two models, or a model and a database or script file. When you choose Complete Compare from the Tools menu, an easily navigated wizard provides a wide range of compare criteria, enabling you to resolve the differences between the models, database, or script file.

After you select the models you want to compare, you can narrow the range of the comparison by filtering out specific properties and objects. In simpler scenarios, you can accept the preset compare defaults and begin the compare process immediately. You can create custom option sets for filtering objects, and save the option sets for future use. You can save a compare session for future reference, and create reports on the differences detected during the compare process.

When you begin to compare your models, changes are made in real time to the open models in the workspace. You can undo, redo, and reverse compare actions. When a database or script file is included in the compare, you can also generate alter scripts for the models.

See the following topic for common procedures related to using Complete Compare: Complete Compare Examples.

The full sequence of steps available in the Complete Compare wizard includes the following:

1. Make a selection for the model in the Right Model Selection dialog.
2. Make a selection for the model in the Left Model Selection dialog.
3. If necessary, resolve type conflicts using features in the Type Resolution dialog.
4. Set options for the type of objects to compare in the Type Selection dialog.
5. Set object filter options for the left model in the Left Object Selection dialog
6. Set object filter options for the right model in the Right Object Selection dialog
7. Select advanced options for the compare process in the Advanced Options dialog.
8. Click Compare to display the Resolve Differences dialog.