For specific information about working with SQL Azure, see your Microsoft SQL Azure Database documentation or Transact-SQL Reference for SQL Azure.
Important! To enable SQL Azure features, ensure that you have licensed the SQL Azure extension, and that the license is present on the computer with which you are using CA ERwin Data Modeler.
CA ERwin Data Modeler support of SQL Azure database in this release is similar to the support of SQL Server 2008 r2 because the SQL Azure objects supported in CA ERwin Data Modeler provide functionality similar to the corresponding SQL Server 2008 objects. The following table lists the SQL Server 2008 object categories, and describes how they are supported in CA ERwin Data Modeler for SQL Azure.
|
SQL Server 2008 Object Categories in CA ERwin Data Modeler |
SQL Azure Support |
Subcategory State - Category |
Subcategory State - Support |
|---|---|---|---|
|
Aggregate |
No |
|
|
|
Annotation |
N/A |
|
|
|
Application Role |
No |
Permission |
N/A |
|
Assembly |
No |
Permission |
N/A |
|
Asymmetric Key |
No |
Permission |
N/A |
|
Certificate |
No |
Permission |
N/A |
|
Credential |
No |
|
|
|
Cryptographic Provider |
No |
|
|
|
Database Audit Specification |
No |
Database Audit Action |
N/A |
|
Database Encryption Key |
No |
|
N/A |
|
Database Role |
Yes |
Permission |
Partially supported |
|
Database |
Partially supported |
Filegroup Physical File (sub) Trigger Permission |
No No Partially supported Partially supported |
|
Default |
Partially supported |
|
|
|
Domain |
Partially supported |
Permission |
Partially supported |
|
Diagram |
N/A |
|
|
|
File |
No |
|
|
|
Fulltext Catalog |
No |
Permission |
N/A |
|
Fulltext Stoplist |
No |
Fulltext Stopword |
N/A |
|
Function |
Partially supported |
Permission |
Yes |
|
Login |
Partially supported |
Permission |
No |
|
Model Source |
N/A |
|
|
|
Partition Function |
No |
|
|
|
Partition Schema |
No |
|
|
|
Permission (Server Level) |
No |
|
|
|
Relationships |
N/A |
|
|
|
Resource Pool |
No |
|
|
|
Schema |
Yes |
Permission |
Yes |
|
Script Template |
N/A |
|
|
|
Server Audit Specification |
No |
|
|
|
Server Audit |
No |
|
|
|
Stored Procedure |
Partially supported |
Permission |
Yes |
|
Subject Area |
N/A |
|
|
|
Symmetric Key |
No |
|
|
|
Synonym |
Partially supported |
Permission |
Yes |
|
Table |
Partially supported |
Change Data Capture Child Relationship Column Fulltext Index Index Relationship Spatial Index Trigger XML Index |
No N/A Partially supported No Partially supported N/A Partially supported Partially supported No |
|
Theme |
N/A |
|
|
|
Trigger Template |
N/A |
|
|
|
Trigger (Server Level) |
No |
|
|
|
User Id |
Partially supported |
Permission |
Yes |
|
Validation Rule |
Partially supported |
|
|
|
View |
Partially supported |
Child Relationship Column Index Permission Relationship Trigger |
N/A Partially supported Partially supported Yes N/A Partially supported |
|
Workload Group |
No |
|
|
|
XML Schema Collection |
No |
|
|
Notes:
Domain
|
Copyright © 2013 CA.
All rights reserved.
|
|