Database Reference
In-Depth Information
Working with Data-Tier applications
Data-Tier Applications (DAC) is the newest addition in SQL Server 2008 R2 data management
and Visual Studio 2010 development system. The DAC helps users to develop, deploy, and
manage the data-tier portion of the applications in a flexible manner and more efficiently than
ever before. The key output of DAC is automation and facilitation of database objects and SQL
Server instance level objects within the lifecycle of database systems.
Database objects that fall under this category include:
F
Object permissions
F
Role membership (mappings between users and database roles)
F
Extended properties
F
Statistics
F
Diagrams
F
Plan guides
SQL Server instance-level objects in this category include:
F
Linked servers
F
SQL jobs
F
Certificates
F
Endpoints
F
Credential objects
F
User-defined policies and conditions
F
Role membership (mappings between logins and server roles)
This recipe gives an insight of the DAC process, how to install it, and use it to deploy within
the network.
Getting ready
The self-contained unit of deployment is the first step for the DAC process that enables
the Developers and Database Administrators (DBA) to package the SQL Server objects,
such as database and instance objects into a single-entity called Data-Tier Applications
(DAC) package.
Search WWH ::
Custom Search