Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Nov 17, 2010

Deploying Data-Tier Applications of SQL Server 2008 R2 - Page 2

By Arshad Ali

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.

 Deployment From SSMS
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.

Deployment Wizard - Welcome Screen
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.

Deployment Wizard - DAC Package Selection Screen
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.

Deployment Wizard - Review Deployment Intents Screen
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.

Deployment Wizard - Update Configuration Screen
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.

Deployment Wizard - Summary Screen
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.

Deployment Wizard - Deployment Status Screen
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.

 Verifying Deployment
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.


MSDN: Data-tier Application Overview

MSDN: Deploying Data-tier Application Packages

» See All Articles by Columnist Arshad Ali

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM