Specifications

50 CHAPTER 3 Data-Tier Applications
■
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.
FIGURE 3-5 Specifying DAC properties when using the Extract Data-Tier Application Wizard
6. Next, indicate where the DAC package le is to be saved. Remember to use the appro-
priate extension, .dacpac. Alternatively, click the Browse button and identify the name
and location for the DAC package le.
7. You also have the option to select the Overwrite Existing File check box to replace a
DAC package with the same name. If you choose a name that already exists for a DAC
package, the existing le is not automatically overwritten. Instead, an exclamation mark
appears next to the Browse button. The Next button on the page is also disabled until
you change the name you specied or select the Overwrite Existing File check box.
8. After you have entered all the DAC properties, click Next to continue.
9. On the Validation And Summary page, illustrated in Figure 3-6, review the informa-
tion presented in the DAC properties summary tree because these settings are used to
extract the DAC you specied. The wizard checks and validates object dependencies,