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.