Features Supported in Data-tier Applications
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).
Supported Versions of SQL Server
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.
Supported SQL Server Objects
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 |