Improving Availability and enhancing Programmability - Microsoft SQL Server 2008 R2 Administration - page 258

9. Next, the Summary page will be displayed, click Next to continue towards the
Deploy DAC screen that presents a series of actions required to deploy the
data-tier application.
10. The wizard performs the following steps by displaying Results:
Marks the deployment in msdb and prepares the deployment scripts in
memory
Creates a new database with necessary objects and logins, also it contains a
random GUID string
Updates msdb to record the DAC definition and complete the deployment
This should complete the deployment process. At this point if the
process encounters any error, all the changes are undone and rolled
back by the wizard. The result will display the reason for failure and
when the deployment is complete, click Finish to close the wizard.
11. The final step for deploying DACPAC for new applications, is to refresh the Databases
node under SSMS, select and refresh the Data-tier applications node and then
expand to view the entry for the new DAC package.
12. Now we have reached the point where we should follow the instructions to
upgrade a data-tier application to a newer version using the Upgrade data-tier
application wizard.
13. For this recipe, the scenario is that after few weeks of Finance application
deployment, there are a few new changes and bugfixes by the Developers bearing the
version number as 2.0.0.0.
14. As in the previous process, locate the package file containing the newer version of the
data-tier application.
15. After the instance is selected, expand the Management node, right-click the Data-
tier Applications node, and then click Upgrade Data-tier Application to launch the
wizard. As usual, the first screen is an introduction, which provides the description to
read, then click Next to continue.
16. On the Select Package page, click Browse to navigate to the file and review the
selected package name, then click Next.