Creating Models › Target Servers for Physical Models › Database Property Editors › New r8 SQL Server 2008 Support in CA ERwin Data Modeler

New r8 SQL Server 2008 Support in CA ERwin Data Modeler

CA ERwin Data Modeler r8 provides enhanced support for the SQL Server 2008 database. All relational syntax and security objects are supported, and new objects are provided to support auditing and resource management.

The following SQL Server 2008 features are supported:

• Filtered indexes
• Sparse columns
• Change data capture
• Synchronous net-changes change tracking
• New data types

New physical objects to support SQL Server 2008 include:

• Cryptographic Providers
• Database Audit Specifications
• Database Encryption Keys
• Full-text Stoplists
• Resource Pools
• Server Audit Specifications
• Server Audits
• Spatial Indexes
• Workload Groups