Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

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 ready

There are no specific hardware or software requirements for data-tier applications except that the SQL Server version must be 2008 R2. Additionally, the data-tier applications can be used to work with existing databases using SSMS or used to...