Your work may take place primarily in VSTS Database Edition, or in CA ERwin DM. Four typical workflow scenarios exist for integrating VSTS Database Edition schemas and CA ERwin DM data models:
This is the most common workflow, and the one recommended for ease of use. You have an existing VSTS Database Edition project to which you want to add a CA ERwin DM data model. Your work begins in VSTS Database Edition, you add a data model to the project, and then use the integrated CA ERwin DM features to create, modify, and save a data model with the VSTS Database Edition project.
After you add a CA ERwin DM model to the VSTS Database Edition project, you can edit the project using CA ERwin DM. Your changes to the data model are automatically synchronized with the VSTS Database Edition schema when you save and close the model. In addition, any independent changes made to the VSTS Database Edition project are copied to the CA ERwin DM model the next time you open it.
When you have an existing CA ERwin Data Modeler model that you want to associate with a VSTS Database Edition project, you can use the Complete Compare features in CA ERwin Data Modeler to import objects and properties into a new model you create in VSTS Database Edition.
You can import objects to your model already associated with a VSTS Database Edition project using VSTS Database Edition or CA ERwin Data Modeler. You can import objects to your model using the existing features of CA ERwin Data Modeler.
You can work on a data model in CA ERwin DM that has been integrated with a VSTS Database Edition project. You do this by opening the model in a standalone copy of CA ERwin DM. You can save your changes and synchronize them with the VSTS Database Edition project the next time you open VSTS Database Edition.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |