| CA |
4.0 Supported Target Server Databases
5.0 Installation Considerations
5.1 Installing the Visual Studio Team Edition for Database Professionals - AllFusion ERwin DM Integration
5.2 Installing API Components
5.3 Requirement for Connecting to SQL Server 2005
6.0 General Considerations
6.1 Template Files for Customizing Model Explorer Display
6.2 Multiple Constraints on Columns
6.3 Message When Reverse Engineering an Oracle 9i Script
6.4 Sybase CHECK Constraints
6.5 Synchronization Limitation With Visual Studio and AllFusion ERwin DM
Welcome to AllFusion ERwin Data Modeler r7.2, a member of the AllFusion Modeling Suite. This file contains operating system support, system requirements, a list of supported target server databases, installation considerations, known issues, documentation notes, and information about contacting CA Customer Support.
AllFusion ERwin Data Modeler requires that you have one of the following operating systems installed:
Microsoft Visual Studio 2005 Team Edition for Database Professionals (Service Release 1), part of the Microsoft Visual Studio 2005 Team Suite is required to use the integration features with Allfusion ERwin Data Modeler. You also must install the Visual Studio Team Edition for DB Professionals Power Tools. An option to install these tools is provided on the last screen of the AllFusion ERwin DM installation wizard.
The following requirements must be met or exceeded for AllFusion ERwin DM r7.2 to install and run correctly:
The following target server databases are supported in AllFusion ERwin Data Modeler r7.2.
Review the following installation considerations before installing the product.
When you run setup for AllFusion ERwin DM r7.2, the installation script checks for a copy of Microsoft Visual Studio 2005 Team Edition for Database Professionals. If it detects a copy, the integration components are automatically installed unless you cancel the selection to install the components. You can also modify an existing installation of AllFusion ERwin DM r7.2 to add the Visual Studio integration. See the installation instructions in Chapter 1 of the Integration Guide, provided in PDF format in the \Doc folder where AllFusion ERwin DM is installed.
The AllFusion ERwin Data Modeler API and two related components (ERwin SPY, and the ERwin Sample API Client) are included in the installation when you choose the Complete Setup Type during setup. If you choose the Custom Setup Type during setup, you can choose to customize the install location, and review the space needed to install each feature.
If you are trying to connect to an AllFusion Model Manager database which resides on SQL Server 2005 from a machine that does not have the SQL Server 2000 client installed, you will not be able to connect to AllFusion Model Manager. AllFusion Model Manager requires the use of DB-Library for connecting to SQL Server databases. SQL Server 2005 no longer distributes the DB-Library files, though DB-Library is supported for connecting to SQL Server 2005.
In order to be able to connect to an AllFusion Model Manager database which resides on SQL Server 2005, the file NTWDBLIB.DLL needs to be installed to the c:\windows\system32 folder on your workstation. If you have a SQL Server 2000 installation CD, the SQL Server 2000 client can be installed from the CD by executing sqlredis.exe located on in the \x86\Other folder. If you do not have a SQL Server 2000 installation CD, you can find the file in a directory named "support" on the root of the AllFusion ERwin DM CD.
This section contains general information you should know before using AllFusion ERwin Data Modeler r7.2.
Two template files are provided with AllFusion ERwin Data Modeler that let you customize the display of object names in the Model Explorer. By using macros in the template file, you can override the default display of selected object names.
The file ModelExplorer logical display names.tmpl includes display options for the logical model. The file ModelExplorer physical display names.tmpl includes display options for the physical model. The files are installed to the default installation directory for the product (C:\Program Files\CA\AllFusion ERwin Data Modeler r7).
Comments and a sample macro are provided in the file to customize the display of the parent/child relationship phrase in the Model Explorer. By default, the display is formatted to include the elements <parent name> <relationship name> <child name>. You can modify the macro to exclude one of the elements, for example if you wanted to exclude the parent name in the display.
Note: If you modified the template file with build r7.1, note that the syntax in the files has changed. The templates no longer use the delimiters "{#" and "#}" to enclose text.
Support for multiple constraints on columns in SQL Server 2000 or SQL Server 2005 in an AllFusion ERwin DM model is not currently available.
You may encounter an error message when you reverse engineer an Oracle 9i script that includes comments that are not associated with an object. The reverse engineering process does not create a table for such comments. This matches the behavior in Oracle, in which properties without an associated object are not generated in the physical database.
CHECK constraints are treated differently in Sybase version 12.5 and 12.6/12.7. If you forward engineer a model to a Sybase 12.5 database, table/column CHECK constraints are not enforced, so the UNENFORCED keyword is required. If you forward engineer a model to a Sybase 12.6 or Sybase 12.7 database, CHECK constraints are enforced, so the UNENFORCED keyword is not required.
AllFusion ERwin DM currently supports Sybase 12.5 syntax. For later releases, you must edit the DDL for CHECK constraints to successfully execute on the database.
When you add an AllFusion ERwin DM model to a Visual Studio project, a connection is established between AllFusion ERwin DM and Visual Studio. When you save and close your AllFusion ERwin DM model, your changes are made to the Visual Studio schema.
A known problem with the Microsoft Visual Studio API results in certain user objects not being renamed or deleted from the Visual Studio schema after being renamed or deleted in the AllFusion 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 Visual Studio project. You must manually delete the instances of these object types from the Visual Studio Schema View. If you do not manually modify the Visual Studio schema, the objects are automatically repopulated into the AllFusion ERwin DM model the next time you open it in Visual Studio.
This issue will be resolved when an updated API is available from Microsoft.
There are no known issues for this release.
All published fixes for this product can be found through Published Solutions on SupportConnect.
Updated guides for this product are available at http://ca.com/support.
The PDF guides for this product are as follows:
To view PDF files, you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer.
The release number on the title page of a document might not correspond to the current product release number; however, all documentation delivered with the product, regardless of release number on the title page, will support your use of the current product release. The release number changes only when a significant portion of a document changes to support a new or updated product release. If no substantive changes are made to a document, the release number does not change. For example, a document for r7 may still be valid for r7.1 or even r7.2. Documentation bookshelves always reflect the current product release number.
Occasionally, we must update documentation outside of a new or updated release. To indicate a minor change to the documentation that does not invalidate it for any releases that it supports, we update the edition number on the cover page. First editions do not have an edition number.
For online technical assistance and a complete list of locations, primary service hours, and telephone numbers, contact Technical Support at http://ca.com/support.