Microsoft SQL Server 2008 R2 Specifications download pdf (Page 72)

52 CHAPTER 3 Data-Tier Applications

Installing a New DAC Instance with the Deploy

Data-Tier Application Wizard

After the DAC package has been created using the data-tier application project template

in Visual Studio 2010, the Extract Data-Tier Application Wizard in SQL Server Management

Studio, or Windows PowerShell commands, the next step is to deploy the DAC package to

a Database Engine instance running SQL Server 2008 R2. This can be achieved by using the

Deploy Data-Tier Application Wizard located in SQL Server Management Studio.

During the deployment process, the wizard registers a DAC instance by storing the DAC

denition in the msdb system database, creates the new database, and then populates the

database with all the database objects dened in the DAC. If a DAC is installed on a managed

instance of the Database Engine, the Data-Tier Application is monitored by the SQL Server Util-

ity. The DAC can be viewed in the Deployed Data-Tier Applications node of the Management

Studio Utility Explorer and reported in the Deployed Data-Tier Applications details page.

NOTE Data-tier applications can be deployed only on Database Engine instances of SQL

Server running SQL Server 2008 R2. Unfortunately, SQL Server 2008, SQL Server 2005, and

SQL Server 2000 are not supported when you are deploying data-tier applications. How-

ever, upcoming SQL Server cumulative updates or service packs will include functionality

for down-level support.

Follow these steps to deploy a DAC package to an existing SQL Server 2008 R2 Database

Engine instance:

1. In Object Explorer, connect to the SQL Server instance in which you plan to deploy the

Data-Tier Application.

2. Expand the SQL Server instance, and then expand the Management folder.

3. Right-click the Data-Tier Applications node, and then select Deploy Data-Tier Applica-

tion to invoke the Deploy Data-Tier Application Wizard.

4. Review the information in the Introduction page, and then click Next to begin the

deployment process. Select the Do Not Show This Page Again check box if you do not

want the Introduction page displayed in the future when using the wizard.

5. On the Select Package page, specify the DAC package you want to deploy. Alterna-

tively, use the Browse button to specify the location for the DAC package.

6. When the DAC package is selected, verify the DAC details, such as the application

name, version number, and description in the read-only text boxes, as shown in Fig-

ure 3-7. Click Next to continue.

1 2 ... 67 68 69 70 71 72 73 74 75 76 77 ... 235 236

No comments

Microsoft SQL Server 2008 R2 Specifications Page 72