Share via


Property Files in Database and Server Projects

You can modify the values that are contained in property files in database projects and server projects, to control aspects of the database or server to which the project is deployed. These files are contained in the Properties folder of the database or server project in Solution Explorer. This topic describes those files and their contents.

Property Files for Database Projects

The following table describes the files that can occur in database projects and their contents.

File name

Description

Database.sqlcmdvars

Contains the names and values for SQLCMD variables, which are used when you deploy the project. You define one or more .sqlcmdvars files and associate each solution configuration with one .sqlcmdvars file. For more information, see How to: Define Variables for Database Projects.

Database.sqldeployment

Contains deployment-specific settings, such as database name and target connection string. You define one or more .sqldeployment files and associate each solution configuration with one .sqldeployment file. For information about how to configure these properties, see How to: Configure Deployment Settings for Database and Server Projects and How to: Configure Properties for Deployment Details.

Database.sqlsettings

Contains database-specific configuration settings, such as backup policy and collation. All solution configurations share the same .sqlsettings file. For more information, see How to: Configure Database Properties for Database Projects.

Database.sqlpermissions

Contains GRANT and DENY statements that apply permissions to objects in your database. All solution configurations share the same .sqlpermissions file.

Property Files for Server Projects

The following table describes the files that can occur in server projects and their contents.

File name

Description

Master.sqlcmdvars

Contains the names and values for SQLCMD variables that are used when you deploy the project. You define one or more .sqlcmdvars files and associate each solution configuration with one .sqlcmdvars file. For more information, see How to: Define Variables for Database Projects.

Master.sqldeployment

Contains deployment-specific settings, such as the target server. You define one or more .sqldeployment files and associate each solution configuration with one .sqldeployment file. For information about how to configure these properties, see How to: Configure Deployment Settings for Database and Server Projects and How to: Configure Properties for Deployment Details.

Master.sqlsettings

Contains configuration settings that can be deployed to the master database (SET ANSI_NULLS, SET ANSI_PADDING, SET ANSI_WARNING, SET ARITHABORT, SET CONCAT_NULL_YIELDS_NULL, SET NUMERIC_ROUNDABORT, SET QUOTED_IDENTFIER, Trustworthy). All solution configurations share the same Master.sqlsettings file. For more information, see How to: Configure Database Properties for Database Projects.

Server.sqlsettings

Contains server settings that can be verified when you deploy the project, such as Server Collation and CLR Enabled. All solution configurations share the same Server.sqlsettings file. For more information, see How to: Configure Server Properties for Server Projects.

Master.sqlpermissions

Contains GRANT and DENY statements that apply permissions to objects in your "master" database. All solution configurations share the same .sqlpermissions file.

See Also

Concepts

Starting Team Database Development

Configuring Database Projects and Performing a Test Deployment

Writing and Changing Database Code

Build and Deploy Databases to an Isolated Development Environment