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.