Working with Data Models › How Complete Compare Works › Complete Compare Examples › Compare a Local Model and a Large Database

Compare a Local Model and a Large Database

Use the following sequence of steps to create a compare session with a model and a large database. When you use this process, only database objects that match the objects selected from the model are loaded from the database.

Note: This process is only relevant when working with Oracle, SQL Server 2005/2008 and Teradata databases.

In this example, your local model is set as the left model in the Complete Compare wizard, and the database is set as the right model.

To compare a local model and a large database

1. Open the data model that you want to compare to the script file or database, then click Complete Compare on the Actions menu.

   The Complete Compare wizard opens, on the Right Model Selection pane.

2. Click the link for Advanced Options. In the Advanced Options pane, select the check box for "Exclude unaligned objects in the right model."

   If you want to filter objects from the left model, select the links for the Type Selection and Left Object Selection and work with the filters in those panes of the wizard.

3. Load your database as the right model. To do this, click the link in the Complete Compare wizard for the Right Model pane, select the "Load from Database/Script" option and select the Allow Demand Loading option. Click Load.

   The Reverse Engineer wizard opens.

4. Work with the Reverse Engineer Wizard to select a template and set reverse engineer options. Click Next in the Reverse Engineer - Set Options dialog. Enter your database connection credentials and click Connect.

   The reverse engineering process runs, and your database appears as the "Right Model" in the Complete Compare wizard. The compare level, type, and object selections are reset to their default values. Any filtering of objects in the left model will be reset.

5. Use the options in the Complete Compare Wizard to set the compare level and filter by objects for either model.
6. Click Compare to start the compare process.

   The two models are compared, and the Resolve Differences dialog opens. Your right model only displays objects that are aligned to the unfiltered objects in the left model.

7. Use features in the Resolve Differences dialog to compare and reconcile any detected differences between the models.

   Note: If you move objects or properties into your model based on the database (the right model) you can generate an alter script against the database. Click the Right Alter Script/Schema Generation icon to open the Alter Script wizard.

8. Click Finish.

   You return to the Complete Compare Wizard. You can change any options in the wizard and begin the compare process again, or click Close to close the wizard.

   The wizard closes and you return to the main workspace.

Note: An Advanced Option, "Auto-Dispose Database/Script Models" is selected by default. This means that the model reverse-engineered from your database is automatically closed without saving at the end of the Complete Compare session.

More information:

Complete Compare Wizard Summary