Specifications

44 CHAPTER 3 Data-Tier Applications
Real World
O
rganizations looking to accelerate and standardize deployment of database
applications within their database environments should leverage data-tier
applications included in SQL Server 2008 R2. By utilizing data-tier applications, an
organization captures intent and produces a single deployment package, providing
a more reliable and consistent deployment experience than ever before. In addition,
data-tier applications facilitate streamlined collaboration between development
and database administrator teams, which improves efciency.
Supported SQL Server Objects
Every DAC contains objects used by the application, including schemas, tables, and views.
However, some objects are not supported in data-tier applications. The following list can help
you become acquainted with some of the SQL Server objects that are supported.
■
Database role
■
Function: Inline Table-valued
■
Function: Multistatement Table-valued
■
Function: Scalar
■
Index: Clustered
■
Index: Non-clustered
■
Index: Unique
■
Login
■
Schema
■
Stored Procedure: Transact-SQL
■
Table: Check Constraint
■
Table: Collation
■
Table: Column, including computed columns
■
Table: Constraint, Default
■
Table: Constraint, Foreign Key
■
Table: Constraint, Index
■
Table: Constraint, Primary Key
■
Table: Constraint, Unique
■
Trigger: DML