Working with Data Models › How Complete Compare Works › Complete Compare Wizard Summary › Select the Right Model in the Complete Compare Wizard

Select the Right Model in the Complete Compare Wizard

Use the options in the Complete Compare Right Model Selection dialog to select a model, script, database, or a model located in a mart that will be displayed in the right pane of the Resolve Differences dialog.

To select the right model in the Complete Compare wizard

1. Click Actions, Complete Compare.

   The Complete Compare wizard opens.

2. Click Right Model.

   The Right Model Selection pane opens.

3. Load a model, script, or database from one of the following sources:

   File

   Opens a model from a local file. Click Load to browse for the file.

   Database/Script

   Les you select a script file or database. You are prompted to select the script file or database using the Reverse Engineer wizard. You use the Reverse Engineer wizard to create the list of model objects and properties in the right model pane. The selected database or script is reverse engineered to a new model in the workspace.

   Note: If you choose to reverse engineer from a script file, select a file that is saved either in ANSI or ASCII format.

   Allow Demand Loading

   When you reverse engineer a database or script, improves the performance by loading only the names of top-level objects (tables, views, materialized views). This enables Complete Compare to load the database quickly since it is only comparing names at this point. When you align or perform an action on a partially loaded object in the Resolve Differences pane of the Complete Compare Wizard, the properties are fully loaded to complete the compare action. Clear this check box to suppress the default setting. Clear the Allow Demand Loading check box if you plan to work with the model you reverse engineered from the database after using Complete Compare. If you do not clear Allow Demand Loading, the resulting model will only be partially loaded and will be missing the substructure of various object, tables, views, and so on.

   Mart

   Opens a model from a mart. Before you select this option, connect to the mart using the Connection Manager from the File, Mart menu. The Library Manager opens, and you can select the model from a library.

   Set selected model as read-only

   Loads the model as read-only. When you work with the model in the Resolve Differences dialog, you cannot make changes to it. Use this feature to perform a "one-way" compare.

4. Click Next to continue to the next pane.

   The right model selection is saved.

More information:

Complete Compare

Complete Compare Examples

Complete Compare Wizard Summary