New Features and Enhancements › Database Support Update

Database Support Update

Databases Added

Support has been added for the following target server database in CA ERwin Data Modeler r8.2:

• SQL Azure

  Notes:

  • If you plan to use SQL Azure as your target server, verify that your SQL Azure license is present on the computer on which you plan to run CA ERwin Data Modeler. If it is not present, you are unable to select SQL Azure as a target server.
  • Review Connecting to SQL Azure for specific connection information.

SQL Azure support is included for the following functional areas in CA ERwin Data Modeler:

• Model creation
• Reverse engineering
• Derive model
• Forward-engineering

Note: The principal Application Role is not supported in SQL Azure. Any property editor that provides a way to set permissions on an object will not have Application Role available for selection in the list of Principals to Grant.

Support is provided for the following objects:

• Databases
• Database Roles
• Domains
• Default Values
• Functions
• Indexes
• Logins
• Schemas
• Spatial Indexes
• Stored Procedures
• Synonyms
• Tables
• Triggers
• User IDs
• Validation Rules
• Views