Data-tier Applications in SQL Server 2008 R2

Writers: Alan Brewer, Roger Doherty, Prashant Choudhari, Shireesh Thota, Charlie Carson, Omri Bahat

Technical Reviewers: Jen Witsoe, S Muralidhar, Clifford Dibble, Sanjay Nagamangalam

Published: February 2010

Applies to: SQL Server 2008 R2

Microsoft’s investments in application and multi-server management will help reduce the complexity around developing, deploying, and managing applications. A core concept of application and multi-server management in SQL Server is the data-tier application (DAC). A DAC, introduced in the Microsoft® SQL Server® 2008 R2 data management software and the Microsoft Visual Studio® 2010 development system, is a self-contained unit of deployment that defines and bundles database objects, SQL Server instance objects that are associated with the database, and deployment requirements of an application. Using DACs, developers and database administrators can automate and facilitate common operations and practices in the lifecycle of database systems.

 - DownloadData-tier Applications in SQL Server 2008 R2” from the Microsoft Download Center

 - Ask a question in the SQL Server Forums

 - Send Feedback on the white paper