631
Chapter 23: Transferring Databases
23
To begin creating and deploying DACs, you must fi rst register a database as a DAC and then
register that DAC defi nition to the instance. Follow these steps to register a database as a DAC:- Right-click the database, and from the context menu, choose Tasks ➪ Register as
Data-Tier Application. - At the Introduction menu, click Next.
- The DAC instance name is automatically the name of the database you register.
- You can customize the Application name. If the database is associated with a par-
ticular application, you may want to use that name here so you can easily refer to
it for a particular application. - Version level is set to 1.0.0.0 by default but can be manually incremented as
needed. - In the description fi eld, supply a quick description of what the database is and
what application is associated with it. Click Next to proceed. - The DAC Wizard then validates all the objects in the database. When complete, you
see a summary of your options selected as well as the validation checks. Click Next
to proceed. - The DAC is then registered to the instance. Click Finish.
Now that you’ve registered your database as a DAC application, it’s time to defi ne its
contents. - Right-click the database you registered in previous steps, and from the context
menu, select Tasks ➪ Extract Data-Tier Application. - At the Introduction menu, click Next.
- Here you supply the properties of the DAC. Give the Application a name and version
number.
Properly versioning your DAC application is important because this lets those who deploy the DACs in other environ-
ments know which revision level they are upgrading to.- Select a location to save the DAC package fi le (.dacpac) to by clicking the Browse
button and navigating to your wanted location on your fi le system. If you want to
overwrite an existing DAC package fi le, check the box for Overwrite existing fi le. - Click Next to proceed to Validation and Summary.
- Click Next to proceed and build your DAC package.
- Click Finish when complete.
c23.indd 631c23.indd 631 7/31/2012 9:25:23 AM7/31/2012 9:25:23 AM
http://www.it-ebooks.info