CA ERwin Data Modeler And Microsoft Visual Studio Team .
CA ERwin Data Modeler andMicrosoft Visual Studio TeamSystem 2008 Database Edition Integration Guider7.3
This documentation and any related computer software help programs (hereinafter referred to as the“Documentation”) is for the end user’s informational purposes only and is subject to change or withdrawal by CA atany time.This Documentation may not be copied, transferred, reproduced, disclosed, modified or duplicated, in whole or inpart, without the prior written consent of CA. This Documentation is confidential and proprietary information of CAand protected by the copyright laws of the United States and international treaties.Notwithstanding the foregoing, licensed users may print a reasonable number of copies of the Documentation fortheir own internal use, and may make one copy of the related software as reasonably required for back-up anddisaster recovery purposes, provided that all CA copyright notices and legends are affixed to each reproduced copy.Only authorized employees, consultants, or agents of the user who are bound by the provisions of the license forthe Product are permitted to have access to such copies.The right to print copies of the Documentation and to make a copy of the related software is limited to the periodduring which the applicable license for the Product remains in full force and effect. Should the license terminate forany reason, it shall be the user’s responsibility to certify in writing to CA that all copies and partial copies of theDocumentation have been returned to CA or destroyed.EXCEPT AS OTHERWISE STATED IN THE APPLICABLE LICENSE AGREEMENT, TO THE EXTENT PERMITTED BYAPPLICABLE LAW, CA PROVIDES THIS DOCUMENTATION “AS IS” WITHOUT WARRANTY OF ANY KIND, INCLUDINGWITHOUT LIMITATION, ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSEOR NONINFRINGEMENT. IN NO EVENT WILL CA BE LIABLE TO THE END USER OR ANY THIRD PARTY FOR ANYLOSS OR DAMAGE, DIRECT OR INDIRECT, FROM THE USE OF THIS DOCUMENTATION, INCLUDING WITHOUTLIMITATION, LOST PROFITS, BUSINESS INTERRUPTION, GOODWILL, OR LOST DATA, EVEN IF CA IS EXPRESSLYADVISED OF SUCH LOSS OR DAMAGE.The use of any product referenced in the Documentation is governed by the end user’s applicable licenseagreement.The manufacturer of this Documentation is CA.Provided with “Restricted Rights.” Use, duplication or disclosure by the United States Government is subject to therestrictions set forth in FAR Sections 12.212, 52.227-14, and 52.227-19(c)(1) - (2) and DFARS Section 252.2277014(b)(3), as applicable, or their successors.All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.Copyright 2008 CA. All rights reserved.
CA Product ReferencesThis document references the following CA products: CA ERwin Data Modeler Microsoft Visual Studio 2005 Team Edition for Database Professionals Microsoft Visual Studio Team System 2008 Database EditionContact CAContact Technical SupportFor online technical assistance and a complete list of locations, primary servicehours, and telephone numbers, contact Technical Support athttp://ca.com/support.Provide FeedbackIf you have comments or questions about CA product documentation, you cansend a message to techpubs@ca.com.If you would like to provide feedback about CA product documentation, pleasecomplete our short customer survey, which is also available on the CA Supportwebsite.
ContentsChapter 1: Overview and Installation7How CA ERwin Data Modeler and Microsoft Visual Studio Team System 2008 Database EditionWork Together . 7Installation Considerations . 8Install VSTS Database Edition and CA ERwin DM . 8Add VSTS Database Edition to an Existing Installation of CA ERwin DM . 9Chapter 2: Work with CA ERwin DM Models in VSTS Database Edition11Workflow Scenarios . 12Add a CA ERwin DM Model to a VSTS Database Edition Project. 13Update a Model Already Associated With a VSTS Database Edition Project . 16Associate an Existing CA ERwin DM Model With a VSTS Database Edition Project . 17Import Objects to a Model Already Associated with a Visual Studio Project. 18Work With a Data Model Outside VSTS Database Edition . 18Save a CA ERwin DM Model in VSTS Database Edition . 19Warning Message - One Model Per Project . 20Chapter 3: Data Model and Database Project Synchronization21Synchronize a CA ERwin DM Model with a VSTS Database Edition Project . 21Understanding Complete Compare Results . 22How Icons Identify Actions in the Resolve Differences Dialog . 23Resolve Differences Standard Toolbar . 23Resolve Differences Impact Analysis Toolbar . 24Resolve Differences - Known Differences Toolbar . 25Resolve Differences - Standard Filters Toolbar . 26Resolve Differences Navigation Toolbar . 27Search the Resolve Differences Dialog . 28Generate a Comparison Report . 29Work With Snapshots in the Resolve Differences Dialog . 30Manage Model Snapshots . 31Index33Contents 5
Chapter 1: Overview and InstallationThis section contains the following topics:How CA ERwin Data Modeler and Microsoft Visual Studio Team System 2008Database Edition Work Together (see page 7)Installation Considerations (see page 8)Install VSTS Database Edition and CA ERwin DM (see page 8)Add VSTS Database Edition to an Existing Installation of CA ERwin DM (seepage 9)How CA ERwin Data Modeler and Microsoft Visual StudioTeam System 2008 Database Edition Work TogetherCA ERwin Data Modeler (CA ERwin DM) simplifies the design, generation, andmaintenance of high-quality, high-performance databases, data warehouses,and enterprise data resource models. It also enables developers and ITarchitects to more readily visualize the optimal structure and design of theirdatabases and other applications based on their organization's informationrequirements and business rules.Microsoft Visual Studio Team System 2008 Database Edition (VSTS DatabaseEdition) delivers a database development product designed to managedatabase change, improve software quality through database testing, andbring the benefits of VSTS Database Edition and life cycle development to thedatabase professional.The CA ERwin DM-VSTS Database Edition integration lets you use yourexisting data models, data modeling skills, and data-modeling tools tostreamline the data modeling and schema generation process as follows: Use existing CA ERwin DM database designs to jump-start the creation ofmanaged objects in VSTS Database Edition. Use the design visualization, task automation and advanced modelingfeatures of CA ERwin DM to fine-tune schemas. Reuse data models across the IT environment.Chapter 1: Overview and Installation 7
Installation ConsiderationsInstallation ConsiderationsYou must have a copy of Microsoft Visual Studio Team System 2008 DatabaseEdition installed to enable the CA ERwin DM-VSTS Database Editionintegration.Both the CA ERwin DM and VSTS Database Edition products must be installedon the same PC onal information related to a failed transaction. For longmessages, use the Details feature to display complete information fora selected advisory message.Click Close.The Reverse Engineer From Script dialog closes and you return to the mainCA ERwin DM workplace.Use the full suite of features in CA ERwin DM, such as design layers,naming standards, reverse engineering, forward engineering, andreporting to modify your model.Chapter 2: Work with CA ERwin DM Models in VSTS Database Edition 15
Update a Model Already Associated With a VSTS Database Edition ProjectUpdate a Model Already Associated With a VSTS DatabaseEdition ProjectAfter you add a CA ERwin DM model to a VSTS Database Edition project, themodel and project are linked. This simplifies synchronization when you nextopen the model or project, and also prevents you from adding more than onemodel to a project. This procedure documents the typical synchronizationscenario you encounter when you open your model after revising your VSTSDatabase Edition project. You can either automatically update the model, oruse the CA ERwin DM Resolve Differences dialog to review and resolvedifferences to complete the synchronization.To update a model already associated with a VSTS Database Editionproject1.Start VSTS Database Edition and open a database project. Click Edit inERwin DM on the Data menu.VSTS Database Edition detects that a model is already associated with theproject and displays the Interaction Status dialog.Note: If differences are detected between the project and model, thefollowing message displays: "Do you want ERwin DM to automaticallyupdate the ERwin model based on changes made to the Visual StudioDatabase project?"2.Click Yes to update the model without reviewing the changes(recommended).Click No to open the Resolve Differences dialog. Resolve all differences tocorrectly synchronize the model and project. Work with features in theResolve Differences dialog to review rows that are not equal. Objects andproperties from your CA ERwin DM model display in the left column, andthose 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 alldifferences, the Resolve Differences dialog closes, and the interaction betweenCA ERwin DM and VSTS Database Edition is broken.16 Integration Guide
Associate an Existing CA ERwin DM Model With a VSTS Database Edition ProjectAssociate an Existing CA ERwin DM Model With a VSTSDatabase Edition ProjectYou may have an existing CA ERwin Data Modeler model you want to associatewith a VSTS Database Edition project. You can use Complete Comparefeatures in CA ERwin Data Modeler to import objects and properties from anexisting model into the new CA ERwin Data Modeler model you create fromwithin a VSTS Database Edition project.The process consists of the following steps:1.Open your project in VSTS Database Edition.2.Add a new CA ERwin Data Modeler model.3.In CA ERwin Data Modeler, use Complete Compare to locate the existingCA ERwin Data Modeler model you want to associate with the VSTSDatabase Edition project.4.Use the import feature in Complete Compare to import objects andproperties into the model you created from VSTS Database Edition.5.Save and Close the model in CA ERwin Data Modeler.Your changes are synchronized with the project in VSTS Database Edition.Chapter 2: Work with CA ERwin DM Models in VSTS Database Edition 17
Import Objects to a Model Already Associated with a Visual Studio ProjectImport Objects to a Model Already Associated with a VisualStudio ProjectYou can import objects to your model already associated with a VSTSDatabase Edition project using VSTS Database Edition or CA ERwin DataModeler. You can import objects to your model using the following features ofCA ERwin Data Modeler: Complete Compare Add Model Source Link Model Source Metadata Integration Bridges/ImportAs you work in CA ERwin DM, use the online help to learn about thesemodeling features. A CA ERwin Data Modeler Integration Guide is provided inPDF format and is installed to the \Program Files\CA\ERwin Data Modeler\Doc\folder on the PC where you installed CA ERwin DM.After you import model objects to your ERwin model, your changes to the datamodel are automatically synchronized with the VSTS Database Edition schemathe next time you open the Visual Studio project.Work With a Data Model Outside VSTS Database EditionYou can work with a standalone data model you already associated with aVSTS Database Edition project. For example, you can work with CA ERwin DMmodeling features, such as design layers and naming standards withoutopening the VSTS Database Edition project.To work with a standalone data model, do the following: Start CA ERwin DM from the Start menu or from the icon on your desktop. Open the data model you already associated with a VSTS Database Editionproject. By default, the data model resides in the same folder as thedatabase project. Use modeling features to modify the data model. Save your changes to the local copy of the data model.The next time you launch CA ERwin DM from within VSTS Database Edition,your changes are detected and you are prompted to review and synchronizethe differences.18 Integration Guide
Save a CA ERwin DM Model in VSTS Database EditionSave a CA ERwin DM Model in VSTS Database EditionWhen you add a CA ERwin DM model to a VSTS Database Edition project, adefault model name is automatically created in the folder where your VSTSDatabase Edition database resides. For example, if you work with Database1 inthe C:\My Documents\Visual Studio 2008\Projects\Database1 folder, then adda model, the default model name is Database1.erwin.To save a CA ERwin DM model in VSTS Database Edition1.Click the Save icon on the main toolbar in CA ERwin DM.Your changes are saved to the CA ERwin DM model. While CA ERwin DMand VSTS Database Edition are connected, you can continue to revise andsave your model in CA ERwin DM as you work. It is important to know thatthe changes are only saved on the CA ERwin DM side, and are notautomatically synchronized with VSTS Database Edition until you close themodel.2.Click Exit on the File menu.The Close Model dialog opens.Important: Be sure to select the option to save your model on the Closedialog, or the model closes without saving the changes to the VSTSDatabase Edition project.Chapter 2: Work with CA ERwin DM Models in VSTS Database Edition 19
Warning Message - One Model Per Project3.Click OK.The model closes, a permanent association with the VSTS DatabaseEdition project is established for the model, the synchronization with VSTSDatabase Edition completes, and the connection closes.Note: The model name is also added as an object in the Solution Explorerfor your project in VSTS Database Edition.Important! For future synchronization to be successful, do not move the CAERwin DM model from its default location in the folder with the VSTS DatabaseEdition project. If you move or rename the CA ERwin DM model, VSTSDatabase Edition will create a new model the next time you invoke thesynchronization feature within VSTS Database Edition, and your originallysynchronized model will not be used.Warning Message - One Model Per ProjectYou can only associate one CA ERwin DM model per VSTS Database Editionproject. You can add a model in any of the following ways: Click Add ERwin DM Model in VSTS Database Edition on the Project menu Click Edit in CA ERwin DM on the Data menu Right-click an object in the Solution Explorer, then click Add, ERwin DMModel in the submenuIf VSTS Database Edition detects that a model already exists in the project,the following warning message displays and you are prompted to open themodel already associated with the project:Click Yes to complete the interaction process and open the model.20 Integration Guide
Chapter 3: Data Model and DatabaseProject SynchronizationThis section contains the following topics:Synchronize a CA ERwin DM Model with a VSTS Database Edition Project (seepage 21)Understanding Complete Compare Results (see page 22)How Icons Identify Actions in the Resolve Differences Dialog (see page 23)Search the Resolve Differences Dialog (see page 28)Generate a Comparison Report (see page 29)Work With Snapshots in the Resolve Differences Dialog (see page 30)Manage Model Snapshots (see page 31)Synchronize a CA ERwin DM Model with a VSTS DatabaseEdition ProjectWhen you add a data model to a VSTS Database Edition project, all of theschema objects are automatically imported to the data model. After you makechanges to either the data model or the VSTS Database Edition project, yourchanges are synchronized when you save the model or the schema.However, there are times when you are required to manually synchronize thedata model and the schema, such as when you modify the data model outsideof VSTS Database Edition.When synchronization is required, the (Complete Compare) ResolveDifferences dialog opens, allowing you to review the differences andsynchronize the model and schema.Chapter 3: Data Model and Database Project Synchronization 21
Understanding Complete Compare ResultsUnderstanding Complete Compare ResultsAfter processing your models, the Resolve Differences dialog opens. You canquickly review differences displayed in the Object View.The Standard Filters toolbar affects the display in the Object View. By default,the options to show rows that are not equal and not aligned are selected.Items (rows) that are the same (equal) are not displayed by default, since thiswould add unnecessary information to the comparison table. Items that areresolved (on which a compare action has been performed) also do not display.When you resolve a difference, that row also disappears from the display.You can include both of these display options, equal and resolved, when youclick the relevant icon on the Standard Filters toolbar.Differences are easy to see in the Object View because they are marked withone or more identifying icons.A column displays between the model object label and the object list for theleft model in the Object View table. Rows that are not equal display theicon in this column.Each model also includes columns that list the model objects. For rows thatare not equal, and for which an object appears in one model but not the other,the missing object is identified with a cell marked with cross-hatchesWhen you select a row in the Object View, the Property View is automaticallypopulated. Although the rows in the Property View may be read-only (thesynchronization action must be performed in the Object View pane), you canuse the Property View to display details about the properties of the objectsthat do not match.You synchronize the models simply by moving objects from one model to theother, using the copyicons.When the models are synchronized, the comparison rows (using the defaultstandard display filters described above) appear empty.To save your synchronization changes, click Finish. Your changes have beenmade in real-time, and both the model and the project are updated.22 Integration Guide.
How Icons Identify Actions in the Resolve Differences DialogHow Icons Identify Actions in the Resolve Differences DialogThe toolbars in the Resolve Differences dialog give you quick access to all thecompare features. When you select a row in the Object or Property View area,the relevant toolbar options become active.Resolve Differences Standard ToolbarThe following lists the buttons that you can use in the Resolve DifferencesStandard toolbar and describes the purpose for each button.Copy item to the leftMoves any items that do not match, from the right model to the leftmodel.Copy item to the rightMoves any items that do not match, from the left model to the rightmodel.Match two itemsMatches two items. Use this feature to override automatic matching. Youfirst select an object, click the match icon, then click an object or propertywith which to match the first object. The items then appear on the sameline in the Object View.Unmatch two itemsUnmatches any items that have been matched.UndoUndoes the last operation.RedoRedoes a previous undo operation.Show ReportOpens the Report Dialog to generate a report of the differences betweenthe left and right models.HelpOpens online help for the Resolve Differences dialog.Chapter 3: Data Model and Database Project Synchronization 23
How Icons Identify Actions in the Resolve Differences DialogResolve Differences Impact Analysis ToolbarThe Resolve Differences Impact Analysis and Reporting Toolbar includesshortcuts to the following options:Action LogDisplays a read-only version of the Action Log. The two-pane windowtracks the actions made in the Resolve Differences dialog. You can use theFind feature to search through long lists of transactions. Click the reporticon to open the Data Browser and create a report on the changedifferences.Message LogDisplays advisory messages in the Message Log dialog if you encounterthese messages as you work in the Resolve Differences dialog.Left Alter Script/Schema GenerationGenerates an alter script for the model in the left pane for a comparesession that includes a database or script file. The Schema GenerationAlter Script dialog opens, which guides you through the alter scriptgeneration.Note: Schema generation is not available when you resolve differencesbetween a VSTS Database Edition project and a CA ERwin DM model.Right Alter Script/Schema GenerationGenerates an alter script for the model in the right pane fo
Microsoft Visual Studio 2005 Team Edition for Database Professionals . Microsoft Visual Studio Team System 2008 Database Edition (VSTS Database . 4. On the final install screen, select the option to link to the download site for the Visual Studio Power Tools. Click Finish.
CA ERwin Data Modeler for Microsoft SQL Azure (see page 16) This Release Notes details new features, enhancements, updates, and known issues for all editions of CA ERwin Data Modeler. Note: Depending on the edition of CA ERwin Data Modeler you are using, not all features may be enabled fo
CA ERwin Data Modeler for Microsoft SQL Azure (see page 14) This Release Notes details new features, enhancements, updates, and known issues for all editions of CA ERwin Data Modeler. Note: Depending on the edition of CA ERwin Data Modeler you are using, not all features may be enabled for use. For more information about the differences between .
CA ERwin Data Modeler Workgroup Edition (see page 13) Model Life Cycle Frameworks (see page 14) CA ERwin Data Modeler Workgroup Edition CA ERwin Data Modeler Workgroup Edition provides a multiuser modeling environment that makes coordinated, large-scale modeling possible. It enables collaboration among
The following editions of erwin Data Modeler are available: Academic Edition (see page 13) Standard Edition (see page 11) Workgroup Edition (see page 12) Navigator Edition (see page 13) This Release Notes details new features, enhancements, updates, and known issues for all editions of erwin Data Modeler. Note: Depending on the edition of erwin .
1 Data Modeler Concepts and Usage 1.1 Installing and Getting Started with SQL Developer Data Modeler 1-1 1.2 Data Modeler User Interface 1-2 1.2.1 Menus for Data Modeler 1-4 1.2.2 Context Menus 1-8 1.3 Working with Data Modeler 1-10 1.3.1 Database Design 1-11 1.3.2 Data Types Model 1-11 1.3.2.1 Data Types Diagram and Subviews 1-12
1 Data Modeler Concepts and Usage 1.1 Installing and Getting Started with SQL Developer Data Modeler 1-1 1.2 Data Modeler User Interface 1-2 1.2.1 Menus for Data Modeler 1-4 1.2.2 Context Menus 1-8 1.3 Working with Data Modeler 1-10 1.3.1 Database Design 1-11 1.3.2 Data Types Model 1-11 1.3.2.1 Data Types Diagram and Subviews 1-12
1 Data Modeler Concepts and Usage 1.1 Installing and Getting Started with SQL Developer Data Modeler 1-1 1.2 Data Modeler User Interface 1-2 1.2.1 Menus for Data Modeler 1-4 1.2.2 Context Menus 1-8 1.3 Working with Data Modeler 1-10 1.3.1 Database Design 1-11 1.3.2 Data Types Model 1-11 1.3.
erwin Data Modeler Standard Edition--The essential tool for data modeling. erwin Data Modeler Workgroup Edition--Supports concurrent team modeling for large client/server development projects. Modeling Overview Modeling is one of the most effective techniques for understanding and communicating business rules and processes.
