How to: Configure Database Properties for Database Projects
Each database project contains not only definitions of all database objects in the schema but also a set of database properties, such as database collation or default filegroup. These settings are sometimes known as catalog properties, and each version of SQL Server has a different set. You can find a complete list of them on the Microsoft Web site: Setting Database Options (SQL Server 2005) or Setting Database Options (SQL Server 2008).
Each database project can have multiple build configurations but only one set of database properties, and server projects do not contain database properties. By default, you deploy the database properties together with the schema when you deploy a database project. For information about how to prevent database properties from being deployed, see How to: Configure Deployment Settings for Database and Server Projects.
To configure database properties
In Solution Explorer, expand the database project for which you want to configure database properties, and then expand the Properties folder under it.
Click the Database.sqlsettings file, open the View menu, and then click Open.
Note
You can also double-click the Database.sqlsettings file to open it.
The editor for database properties appears.
After you configure the database properties, open the File menu, and then click Save Database.sqlsettings.
See Also
Tasks
How to: Configure Server Properties for Server Projects
How to: Configure Build Settings for Database and Server Projects
How to: Configure Deployment Settings for Database and Server Projects
How to: Configure Properties for Deployment Details
Concepts
Build and Deploy Databases to an Isolated Development Environment
Build and Deploy Databases to a Staging or Production Environment