Previous Topic: Metadata Elements Renamed

Next Topic: Known Issues


Synchronization Limitation With VSTS Database Edition and CA ERwin Data Modeler

When you add a CA ERwin DM model to a VSTS Database Edition project, a connection is established between the two products. When you save and close your CA ERwin DM model, your changes are made to the VSTS Database Edition schema.

A known problem with the Microsoft VSTS Database Edition API results in certain user objects not being renamed or deleted from the VSTS Database Edition schema after being renamed or deleted in the CA ERwin DM model. This applies to objects that are not owned by the schema, such as user, database role, partition function, partition scheme, and the schema itself. If you rename or delete these objects from a model and save your changes, the objects are not automatically renamed or deleted in the VSTS Database Edition project. You must manually delete the instances of these object types from the VSTS Database Edition Schema View. If you do not manually modify the VSTS Database Edition schema, the objects are automatically repopulated into the CA ERwin DM model the next time you open it in VSTS Database Edition.

This issue will be resolved when an updated API is available from Microsoft.