O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deploying and managing data-tier applications

Data-tier application (DACPAC) enables developers to develop, deploy, and manage their applications using traditional development methodologies. SQL Server 2008 R2 added several new features and enhancements with a new unit of deployment to make the deployment and upgrade processes of data-tier applications from Visual Studio 2010 and SSMS tool easier. The management aspect of DACPAC trend analysis is handled by the SSMS tool using SQL Server Utility Control Point (UCP), which enrolls them to monitor the performance and configuration of instance and application level.

In this recipe, we will go through the required steps in order to design and manage data-tier applications in the data platform.

Getting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required