Extract Data-tier Application Wizard (Set Properties Page)

Use this page of the wizard to describe the data-tier application (DAC). These properties are used to identify the DAC and help distinguish it from others.

  • Name:
    This name identifies the DAC. It can be different than the name of the DAC package file and should describe your application. For example, if the database is used for a finance application, you may wish to name the DAC Finance.

  • Version (use xx.xx.xx.xx, where x is a number):
    A numeric value that identifies the version of the DAC. The DAC version is used in Visual Studio to identify the version of the DAC that developers are working on. When deploying a DAC, the version is stored in the msdb database and can later be viewed under the Data-tier Applications node in SQL Server Management Studio.

  • Description:
    Optional. Describes the DAC. When deploying a DAC, the description is stored in the msdb database and can later be viewed under the Data-tier Applications node in Management Studio.

  • Save to DAC package file (include .dacpac extension with file name):
    Saves the DAC to a DAC package file, with a .dacpac extension. Click the Browse button to specify a name and location for the file.

  • Overwrite existing file.
    Select this check box to replace the DAC package file if one already exists with the same name.