Specifications
56 CHAPTER 3 Data-Tier Applications
5. On the Set Properties page, complete the DAC properties by typing in the application
name, version, and description, as described here:
■
Application name This refers to the name of the DAC. This value cannot be
altered and is always identical to the name of the database.
■
Version The DAC version identication helps developers working in Visual Studio
identify the version in which they are currently working. In addition, creating a ver-
sion helps identify the version of the DAC package used during deployment. The
DAC version information is stored in the msdb database and can be viewed in SQL
Server Management Studio in the Data-Tier Applications node.
■
Description This property is optional. Use it to describe the DAC. If this section
is completed, the information is saved in the msdb database under the Data-Tier
Applications node in Management Studio.
6. On the Validation And Summary page, review the information presented in the DAC
properties summary tree because these settings are used to register the specied DAC.
The wizard checks and validates SchemaName, ObjectName, and object dependencies,
and it conrms that the information is supported by the DAC. Review the summary. It
displays DAC object issues, DAC object warnings, and the DAC objects supported. If
there are no issues, click Next to continue. You can also click Save Report to capture
the entire report.
7. The Register DAC screen indicates whether or not the DAC was successfully registered
in the msdb system database. Review the success and failure of each action, and then
click Finish to conclude the registration process.
The data-tier application can now be viewed under the Data-Tier Applications node in SQL
Server Management Studio. Moreover, if a database resides on a utility-managed instance,
resource utilization associated with the data-tier application can be viewed in Utility Explorer
after you connect to a Utility Control Point.
Deleting a Data-Tier Application
Database administrators may encounter occasions when they need to delete a data-tier applica-
tion from an instance of SQL Server. This is accomplished by using the Delete Data-Tier Applica-
tion Wizard in SQL Server Management Studio. Database administrators should be aware that
they will be prompted by the wizard to choose one of three predened options for handling
the database linked to the application before the DAC is deleted. The three options are
■
Delete Registration This method keeps the associated database and login in
place while deleting the DAC metadata from the instance.
■
Detach Database This method detaches the associated database and removes
the DAC metadata. Detaching the associated database means that although the
data les, log les, and logins remain in place, the database can no longer be refer-
enced by an instance of the Database Engine.