Getting Started with Database Projects

Before you can put a database schema under version control, you must create a database project. This section contains topics that describe how you create the database project for a new or existing version-controlled database. This section also contains topics about tasks that you often perform before you begin development work on that database project. An example of these tasks is defining files and filegroups that you can later use in object definitions.

In This Section

• An Overview of the New Database Project Wizard
  Describes the New Database Project Wizard and gives you information about the settings it contains.

• How to: Create Database Projects
  Describes how to use the New Database Project Wizard to create a database project for an existing database and import the schema for that database into the database project.

• How to: Create Empty Database Projects
  Describes how to create a database project for use in creating a database.

• How to: Import a Database Schema
  Describes how to import database schema and object information into an empty database project.

• Overview of Files and Filegroups
  Provides background information about how to define files, filegroups, and log files in the database project. Information in this topic includes the limitations of those features.

• How to: Add Files and Filegroups
  Describes how to add files, filegroups, and log files to the database project. This topic also describes limitations when you delete files, filegroups, and log files.

• How to: Define Variables for Database Projects
  Describes how to define the variables that are used in the definitions of files, filegroups, and log files. By defining files and filegroups in terms of variables, you can have different file names and paths in different deployments.

Related Sections

• Working with Database Objects
  Provides an overview of the tasks you can perform to work with database objects such as tables, views, and stored procedures.

• How to: Create a Database Object
  Describes how to add a new database object to your database project.

• How to: Modify Database Objects
  Describes how to update a database object definition within your database project.

• Working with Database Scripts
  Contains topics that give you information about how you can add deployment or management scripts to your database project.

• Terminology Overview of Team Edition for Database Professionals
  Defines terms used in Visual Studio Team Edition for Database Professionals.