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

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

  2. Click the Database.sqlsettings file, open the View menu, and then click Open.


    You can also double-click the Database.sqlsettings file to open it.

    The editor for database properties appears.

  3. After you configure the database properties, open the File menu, and then click Save Database.sqlsettings.

Community Additions