Deploying Data-Tier Applications of SQL Server 2008 R2 - Page 2
November 17, 2010
Deployment using SQL Server Management Studio (SSMS) SQL Server 2008 R2
To deploy an already created DAC package, right click on Data-tier applications under the Management node in Object Explorer of SSMS and click on Deploy Data-tier Application menu as shown below.
This will launch the Deploy Data Tier Application wizard. The first screen of the wizard is the Welcome screen, which tells what this wizard is going to do for deployment as shown below.
The next screen of the wizard asks you the location and name of the DAC package, which you want to deploy. Then it reads details from the specified DAC and displays it in the bottom section.
The Review Policy page displays all of the deployment intents defined in the package, its expected value and actual value on the target. If it passes the checks it lets you go on to the next page.
In the Update Configuration page, you can change the default application (database) name and locations (locations for data file and log file to be created while creating database on the target server) available in the DAC package to something else.
The Summary page of the wizard gives you a summary of your selections in the wizard. If you need to, you can go back and change your selection or click on the Next button to start deployment.
The Deploy DAC page gives you the status of deployment during deployment or after deployment. If you notice, a new database is created with the database name appended with a GUID and then renamed to your original specified database name in the second last step of deployment as shown below. Once the database is created on the target server the DAC application is also registered in the target server as the final step.
Verifying the deployed Data-Tier Applications
To view or verify the deployed DAC application and database, connect to SSMS then check if the database is available or not under the Databases node in the Object Explorer on the target server. Next verify if the DAC application was registered, expand Data-tier Applications node under Management in the Object Explorer and see if your DAC application is available or not. Select your application and press F7 to see the details about the selection.
In this article I demonstrated how you can deploy a Data tier application or DAC package, then I talked about verifying the deployed application. In my next article, I am going to tell you in detail, how you can upgrade your Data-tier application.