New Features and Enhancements › Database Support Update

Database Support Update

The following information describes updates to database support for CA ERwin Data Modeler.

Databases Removed

Support has been dropped for the following target server databases in CA ERwin Data Modeler:

• Ingres 2.5
• Oracle 8i
• Progress 8.x
• SQL Server 7.0

Databases Added

Support has been added for the following target server databases in CA ERwin Data Modeler:

• Oracle 11x
• Teradata 2.6/12 (see Support for Teradata 2.6/12 for more information)
• DB2/zOS 9 (certification)
• SQL Server 2008 (certification)
• DB2 iSeries 6 (certification, r7.3.4 SP1 and later)

User Interface Changes for Selected Databases

Changes have been made to the user interface to support new modeling features for selected databases. Changes include:

• The SQL tab on the View editor for SQL Server, Oracle, and Teradata has been changed. Two tabs are now used to provide the features. A SQL tab provides read-only information about the DDL statement that is used during forward engineering. A User-Defined SQL tab provides a box for editing a user-provided DDL statement. The box is blank by default.
• An enhancement has been added for MySQL. The AUTO_INCREMENT feature is now supported. When you select a numeric datatype such as Integer in the Column editor (MySQL tab), the Identity option becomes available. When you select this option and perform forward engineering, it generates the AUTO_INCREMENT syntax.

  Note: There can be only one AUTO_INCREMENT column per table.

• The Privilege object was replaced by the Permission object for SQL Server 2005/2008 logical/physical and physical models.