For specific information about working with SQL Azure, see your Microsoft SQL Azure Database documentation or Transact-SQL Reference for SQL Azure.
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 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 erwin® Data Modeler for SQL Azure.
|
SQL Server 2008 Object Categories in 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 © 2017 erwin Inc.
All rights reserved.
|
|