Export (0) Print
Expand All

How to: Configure Server Properties for Server Projects

When you create a server project to manage changes to a database server, you should configure the properties of the project so that they match the properties of the server. A database project that refers to the server project might not function correctly if the values do not match when you deploy the database project. For more information, see Starting Team Development of Databases that Reference Shared Server Objects.

NoteNote:

You cannot deploy changes to server settings because many server settings cannot be changed without either restarting the database engine or, in some cases, reinstalling the database.

As a precaution, you can block deployment of a server project that is configured with different values from the values on the database server. You can specify that all values must match for deployment to continue, or you can specify that only certain values must match. When you try to deploy the server project, the values are verified against the database server. Deployment fails if the project and the server do not match based on your specifications.

Each version of SQL Server has a different set of properties. For a complete list of these properties, their default values, and their acceptable values for SQL Server, see "Setting Server Configuration Options" on the Microsoft Web site. If you have installed other database providers, see the product documentation for that database product.

NoteNote:

For each server project, you can create multiple build configurations, but you can specify only one set of server properties.

To view and configure server properties

  1. In Solution Explorer, expand the server project for which you want to configure server properties, and then expand its Properties folder.

  2. Double-click the Server.sqlsettings file.

    The editor for server properties appears.

    NoteNote:

    You can sort the list of server properties by clicking the heading of the column by which you want to sort.

  3. In the Verify column, select the check boxes for any properties that must match for deployment to continue, and clear the check boxes for any properties that do not need to match.

    NoteNote:

    To select or clear the check boxes for all properties, right-click in the list, and then click either Ignore or Verify.

  4. In the Value column, specify any values that you want to change.

  5. On the File menu, click Save Server.sqlsettings.

Community Additions

ADD
Show:
© 2014 Microsoft