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.

Figure 9 - Deployment From SSMS

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.

Figure 10 - Deployment Wizard - Welcome Screen

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.

Figure 11 - Deployment Wizard - DAC Package Selection Screen

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.

Figure 12 - Deployment Wizard - Review Deployment Intents Screen

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.

Figure 13 - Deployment Wizard - Update Configuration Screen

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.

Figure 14 - Deployment Wizard - Summary Screen

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.

Figure 15 - Deployment Wizard - Deployment Status Screen

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.

Figure 16 - Verifying Deployment

Conclusion

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.

References

MSDN: Data-tier Application Overview

MSDN: Deploying Data-tier Application Packages

» See All Articles by Columnist Arshad Ali