This documentation is archived and is not being maintained.

Features Supported in Data-tier Applications

Visual Studio 2010
Important note Important

To create and manage databases using the latest version of Data Tier Applications (DACPAC), install the most recent release of SQL Server Data Tools from Get Started with Microsoft SQL Server Data Tools.

SQL Server 2008 R2 supports the most commonly used SQL Server Database Engine objects in a data-tier application (DAC).

Data-tier applications can only be deployed to instances of the Database Engine running SQL Server 2008 R2, or to SQL Azure. A DAC can be extracted from a database in an instance of SQL Server 2008 R2, SQL Azure, SQL Server 2008, SQL Server 2005, and SQL Server 2000.

Only supported objects can be specified in a data-tier application as it is being authored or edited. The Extract Data-tier Application Wizard in SQL Server Management Studio does not extract a DAC from an existing database that contains objects not supported in a DAC. The wizard reports the objects found that are not supported in a DAC.

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

TYPE: User-defined Data Type

TYPE: User-defined Table Type

USER

VIEW

Show: