Getting Started with Database Projects

  • Article

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.