ServerSelection.sqlpolicy Property Page

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.

Use the ServerSelection.sqlpolicy property page to configure a Server Selection policy. The Server Selection policy is used to define the requirements that an instance of SQL Server must meet to host the data-tier application (DAC).

To configure the policy, you must select the facet properties that you want to use. The Server Selection facet properties are the set of logical properties of the Server object that apply specifically to DAC selection. For example, they include properties such as BuildNumber, Collation, Edition, and Platform.

After you select a facet property, you must then configure the comparison operator, such as "is equal to" or "is like," and the assigned value for the property. The collection of selected facet properties and their associated values form the condition, or the set of requirements, for the policy.

To access this property page, expand the Properties folder for the DAC project in Solution Explorer, right-click ServerSelection.sqlpolicy, and then click Open.

Options

  • Facet properties
    Use this area to select the check box next to each Server Selection facet property that you want to use in the policy.

    After you select a facet property, you must configure its values in the Edit Values dialog box. For more information, see Edit Values Dialog Box.

  • Edit the condition (click links to edit values)
    Use this area to edit values in the condition.

    After you select a Server Selection facet property and configure its values, the configured values are added to the condition. You can click a hyperlinked value to edit the comparison operator or the assigned string, numeric, or Boolean value.

    To remove a value from the condition, in the Facet properties list, clear the check box next to the facet property that you want to remove.

Saving the Policy File

To save the policy file when you are finished, use any of the following methods:

  • Close the ServerSelection.sqlpolicy page, and then save the policy when you are prompted.

  • On the File menu, click Save ServerSelection.sqlpolicy.

  • On the File menu, click Save All.

  • On the File menu, click Save ServerSelection.sqlpolicy As, and then type a new file name.

See Also

Reference

Edit Values Dialog Box

Concepts

Configuring the Server Selection Policy