Deployment using SQL Server Management Studio (SSMS) SQL Server 2008 R2
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.
Figure 9 - Deployment From SSMS
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.
Figure 10 - Deployment Wizard - Welcome Screen
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.
Figure 11 - Deployment Wizard - DAC Package Selection Screen
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.
Figure 12 - Deployment Wizard - Review Deployment Intents Screen
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.
Figure 13 - Deployment Wizard - Update Configuration Screen
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.
Figure 14 - Deployment Wizard - Summary Screen
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.
Figure 15 - Deployment Wizard - Deployment Status Screen
Verifying the deployed Data-Tier Applications
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.
Figure 16 - Verifying Deployment
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.
Data-tier Application Packages
See All Articles by Columnist