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

• An Overview of Database Build and Deployment
  Provides an overview of the steps that are required to build and deploy a new or existing database.

• 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.

• How to: Deploy Changes to New or Existing Databases
  Describes how you deploy the build script for a new or existing database after you build it.

• How to: Control Data Loss during Deployment to an Existing Database
  Describes how you can control whether deployment should be canceled if data loss will occur.

• An Overview of Database Project Settings
  Provides an overview of the settings that control database build and deployment.

• How to: Configure Database Projects for Build and Deployment
  Describes how you can configure build and deployment options for your database project by using the database project properties.

• How to: Specify a Pre-build or Post-build Command Line
  Describes how you can specify commands to execute before you build the database project or after the build has completed.

• Pre-build Event / Post-build Event Command Line Dialog Box (Team Edition for Database Professionals)
  Provides an overview of the dialog box used to construct the pre-build or post-build command lines. This includes the list of macros that you can insert into those command lines.

• How to: Deploy Changes using Team Foundation Build
  Describes how you can create a Team Foundation build type and use it to build and deploy the database project.

• How to: Suppress One or More Types of Warnings
  Describes how you can suppress numbered warnings by using the properties of a database project.

• How to: Configure the Maximum Number of Errors or Warnings
  Describes how you can use the properties of a database project to restrict the number of errors or warnings that appear when you build or deploy the database project.

• Considerations for Preserving Data during Deployment and Schema Updates
  Describes limitations of the settings that block deployment or schema updates when data loss might occur.

Related Sections

• 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.

• Walkthroughs (Creating and Updating Version-controlled Databases)
  Contains walkthroughs that introduce you to creating and deploying a version-controlled database, putting an existing database under version control, modifying database objects, and deploying changes to an existing database that is under version control.

• Troubleshooting Database Project, Build, and Deployment Issues
  Provides help for diagnosing and correcting problems that relate to your database project, as well as problems with building and deploying your version-controlled database.