SQL Server
United States - English
Home
2012
2008 R2
2008
2005
2000
Library
Forums
This topic has not yet been rated - Rate this topic

DAC Support For SQL Server Objects and Versions

A data-tier application (DAC) supports the most commonly used Database Engine objects.

Only supported objects can be specified in a data-tier application as it is being authored or edited. You cannot extract, register, or import a DAC from an existing database that contains objects that are not supported in a DAC. SQL Server 2012 supports the following objects in a DAC.

DATABASE ROLE

FUNCTION: Inline Table-valued

FUNCTION: Multistatement Table-valued

FUNCTION: Scalar

INDEX: Clustered

INDEX: Non-clustered

INDEX: Spacial

INDEX: Unique

LOGIN

Permissions

Role Memberships

SCHEMA

Statistics

STORED PROCEDURE: Transact-SQL

Synonyms

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: HIERARCHYID, GEOMETRY, GEOGRAPHY

TYPE: User-defined Data Type

TYPE: User-defined Table Type

USER

VIEW

The versions of SQL Server have different levels of support for DAC operations. All of the DAC operations supported by a version of SQL Server are supported by all editions of that version.

Instances of the Database Engine support the following DAC operations:

  • Export and extract are supported on all supported versions of SQL Server.

  • All operations are supported on SQL Azure and all versions of SQL Server 2012 and SQL Server 2008 R2.

  • All operations are supported on SQL Server 2008 Service Pack 2 (SP2) or later, and SQL Server 2005 SP4 or later.

The DAC Framework comprises the client-side tools for building and processing DAC packages and export files. The following products include the DAC Framework

  • SQL Server 2012 includes DAC Framework 2.0, which supports all DAC operations.

  • SQL Server 2008 R2 SP1 and Visual Studio 2010 SP1 included DAC Framework 1.1, which supports all DAC operations except export and import.

  • SQL Server 2008 R2 and Visual Studio 2010 included DAC Framework 1.0, which supports all DAC operations except export, import, and in—place upgrade.

  • The client tools from earlier versions of SQL Server or Visual Studio do not support DAC operations.

A DAC package or export file built with one version of the DAC Framework cannot be processed by an earlier version of the DAC Framework. For example, a DAC package extracted using the SQL Server 2012 client tools cannot be deployed using the SQL Server 2008 R2 client tools.

A DAC package or export file built with one version of the DAC Framework can be processed by any later version of the DAC Framework. For example, a DAC package extracted using the SQL Server 2008 R2 client tools can be deployed using either the SQL Server 2008 R2 SP1 or SQL Server 2012 client tools.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ