Introduction to SQL Server 2008 R2 Data-Tier Application Development
Play Introduction to SQL Server 2008 R2 Data-Tier Application Development
SQL Server 2008 R2 introduced a set of improvements known as Application and Multi-Server Management (AMM), designed to reduce the cost and complexity of managing database servers and applications, and to help customers get more out of their SQL Server investments. Reducing the cost and complexity of deploying and maintaining database applications is a key part of the AMM strategy. Developers can now build a single unit of deployment for the Data-tier portion of an application known as a DACPAC. A DACPAC contains metadata that describes all of the objects in a database application, as well as policies that govern their deployment. A single DACPAC can be handed off to an administrator to deploy instead of collections of complicated Transact-SQL scripts. SQL Server 2008 R2 automatically evaluates the policies in the DACPAC during deployment for compliance, creates the associated database objects, and registers the data-tier application. Upgrades are performed automatically from one version of a Data-tier application to another, eliminating the need for administrators to perform manual upgrades. In this session, I’ll show how to develop and deploy a DACPAC from scratch, how to create a DACPAC from an existing database, how to declare developer intent (such as which version and edition of SQL Server and the OS is required) when deploying, and how to manage DACs with SQL Server Management Studio in conjunction with SQL Server 2008 R2 utility control points (UCPs).