CA ERwin DM - Visual Studio Integration › Update a Model Already Associated With a VSTS Database Edition Project

Update a Model Already Associated With a VSTS Database Edition Project

After you add a CA ERwin DM model to a VSTS Database Edition project, the model and project are linked. This simplifies synchronization when you next open the model or project, and also prevents you from adding more than one model to a project. This procedure documents the typical synchronization scenario you encounter when you open your model after revising your VSTS Database Edition project. You can either automatically update the model, or use the CA ERwin DM Resolve Differences dialog to review and resolve differences to complete the synchronization.

To update a model already associated with a VSTS Database Edition project

1. Start VSTS Database Edition and open a database project. Click Edit in ERwin DM on the Data menu.

   VSTS Database Edition detects that a model is already associated with the project and displays the Interaction Status dialog.

   Note: If differences are detected between the project and model, the following message displays: "Do you want ERwin DM to automatically update the ERwin model based on changes made to the Visual Studio Database project?"

2. Click Yes to update the model without reviewing the changes (recommended).

   Click No to open the Resolve Differences dialog. Resolve all differences to correctly synchronize the model and project. Work with features in the Resolve Differences dialog to review rows that are not equal. Objects and properties from your CA ERwin DM model display in the left column, and those from the VSTS Database Edition Project appear in the right column. Use the icons and display filters to resolve all differences.

   After all differences are resolved, the Object View pane appears empty.

   Click Finish.

Important! You are required to reconcile all differences before you click Finish. If you click Cancel in the Resolve Differences dialog before you reconcile all differences, the Resolve Differences dialog closes, and the interaction between CA ERwin DM and VSTS Database Edition is broken.