Export (0) Print
Expand All

Configuring the Server Selection Policy

Visual Studio 2010
Important note Important

To create and manage databases using the latest version of Data Tier Applications (DACPAC), install the most recent release of SQL Server Data Tools from Get Started with Microsoft SQL Server Data Tools.

To create and manage databases using the latest version of Data Tier Applications (DACPAC), install the most recent release of SQL Server Data Tools from Get Started with Microsoft SQL Server Data Tools.

When you create a SQL Server Data-Tier project in Visual Studio, you can choose to configure a Server Selection policy. This policy enables you to specify the requirements that an instance of SQL Server must meet for the data-tier application (DAC) to be deployed on that instance. For example, you can specify the version of the operating system that the target instance of SQL Server must be running, or the edition of SQL Server that must be installed.

Note Note

Configuring the Server Selection policy is optional.

When a database administrator runs the Deploy Data-tier Application Wizard to deploy the DAC on an instance of SQL Server, the policy is evaluated against the selected instance. In the wizard, the database administrator is presented with the evaluation results for each requirement that you defined in the policy. If there are policy violations, the database administrator can choose to cancel the deployment, or to ignore policy violations and continue with the deployment if the violations are not considered critical.

For more information about how to configure the Server Selection policy, see ServerSelection.sqlpolicy Property Page.

For more information about how to deploy DACs, see Deploying Data-tier Applications and How to: Deploy a Data-tier Application in SQL Server Books Online.

Community Additions

ADD
Show:
© 2015 Microsoft