Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 101

The final screenshot of UCP will be as follows:
Once the steps are completed, the unified view of MSM is visible on SSMS from the Utility
Explorer Content on the right-hand side. The unified view is the representation of a successful
implementation of MSM to manage data-tier application deployment.
How it works...
The Data-tier Application (DAC) component helps to adopt a single unit of deployment method
to streamline all the consolidation of SQL Server instances into a unified view.
In this recipe, we used the Visual Studio 2010 template to build the data-tier application that
will stand as multi-server management. The different types of templates and projects are
as follows:
F Database Project: Database project templates are available for SQL Server 2005
and SQL Server 2008. You can use these templates to define databases for mission-
critical and business-critical applications. All objects implemented by the respective
SQL Server version are supported in database projects.