Database Reference
In-Depth Information
DAC
Packaging
File
SQL Server
Management studio
SQL Server
DAC
Packaging
File
Windows Azure SQL
Database
Visual Studio
Production Server
Development Server
Figure 5.7
DAC deployment.
administrator can package the requested database objects and designate the development server
where the package is to be delivered.
Once the DAC package is delivered to the application development server, the data will be imported
into the application that is under development. he deployed DAC package will be controlled by
the server selection policy, which restricts developers' access to the database objects. he application
developers can only access the server instance dedicated to them. Once the application development is
completed, the DAC tool included in Microsoft Visual Studio can be used to update the DAC package
and deliver the package back to the production server. he application developers integrate the entire
DAC package into their project or select only part of the database objects included in the package.
Once a DAC package is deployed on a server, it will upgrade the existing DAC package. If the
DAC package does not exist, a new database will be generated on the server, which includes the
database objects and the users allowed to access the database. When deployed, the DAC package
will generate XML iles that contain the metadata of the DAC package and an SQL ile that con-
tains the SQL script. During the deployment, the SQL script will be run to generate the database
objects, and all the relevant server logins are also created. he applications on the production side
can then be upgraded automatically or manually by the database administrator. Before the appli-
cation can be made available to the public, the database administrator will review the package for
production with SSMS. he database administrator will compare the database objects generated
by the DAC package with those on the production server to make sure they are consistent. After
the review, the database administrator will designate the server instance on the production server.
Figure 5.7 illustrates the DAC deployment process.
ACTIVITY 5.2 DEVELOPMENT OF DACS
In this activity, you will learn how to extract, deploy, and upgrade a DAC. he activity starts
with database object extraction.
TASK 1: EXTR ACTING A DAC FROM A DATABASE
As described earlier, to support application development, you will need to extract database
objects and deploy the extracted package to an application development server. he task
