Extract Data-tier Application Wizard (Validation and Summary Page)
On this page, the wizard validates that all database objects are supported by a data-tier application (DAC). It also checks dependencies across database objects to determine the set of objects that can be successfully included in the DAC. After that, it displays the validation report and summarizes the options that you have selected in this wizard. To change an option, click Previous. To begin extracting a DAC, click Next.
Note If one or more objects are not supported by a DAC, then the Next button is disabled and the extraction process may not continue. In such cases, it is recommended to remove the non-supported objects and then run this wizard again.
Summary:
A summary of the options you have selected are listed under DAC properties. The results of the validation are listed under DAC objects. There are three types of results from the validation:Objects included in DAC successfully: these objects and their dependencies are supported, and can be included in the DAC successfully.
Objects included in DAC with warnings: these objects are supported, but depend on other objects that are not supported in a DAC.
Objects not included in DAC: these objects are not supported and must be removed from the database before successfully extracting a DAC.
The validation process checks multiple levels of dependencies. For example, if a stored procedure depends on a table that uses the unsupported CLR data type, the stored procedure will be listed under Objects included in DAC with warnings.
If one or more objects are not supported by a DAC, then the Next button is disabled and the extraction process will not continue. In such cases, it is recommended to remove the objects that are not supported and then run this wizard again.
Save Report:
Enables you to save an HTML-based file that lists all of the objects under the DAC Objects node in the summary. This report can be useful when some of your database objects are not supported in a DAC. Use the report to change or remove objects that are not supported, before trying to extract the DAC again.