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
Terminology Overview of Database Edition
Starting Team Database Development
Configuring Database Projects and Performing a Test Deployment
Performing Iterative Database Development
Build and Deploy Databases to an Isolated Development Environment