Share via


Building and Deploying Version-controlled Databases

You must build and deploy changes that you make to your database project for them to update your database server. You can build the project for a new deployment, in which case you are preparing a script that will create a database. The script is created from the schemas that are defined in your database project. Alternatively, you can build the project for an existing deployment. In that case, the database project is compared to a specific deployed database, and scripts are created to update that database to match the database project.

In This Section

  • How to: Prepare Database Build Scripts
    Describes how you generate a build script to create a database whose schema matches the database project or update a database to synchronize its schema with the database project.
  • Getting Started with Database Projects
    Contains topics that describe how you create the database project for a new or existing version-controlled database. This process includes importing a schema from an existing database or script into a database project.
  • Modifying Database Projects
    Contains topics that describe how you open and work with an existing database project. This process includes importing schema updates from an existing database into a database project.
  • Working with Database Objects
    Provides an overview and links to topics that describe how you create, modify, and validate changes to database objects such as tables, stored procedures, and functions.
  • Working with Database Scripts
    Contains topics that describe how you create and maintain scripts for deploying database schemas and managing databases.