Share via


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

  • 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.
  • 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.
  • 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.
  • Working with Database Scripts
    Contains topics that give you information about how you can add deployment or management scripts to your database project.