Working with Database Scripts

You can include database scripts as part of your database project. These scripts can run before or after the build script when you first deploy your database or when you deploy changes to it. You can also include other scripts that you use regularly, such as database management scripts, in your database project.

In This Section

• An Overview of Database Scripts
  Provides information about the types of scripts that you can include and how you can affect them.

• How to: Specify Pre-Deployment or Post-Deployment Scripts
  Describes how to specify scripts to be run before or after the deployment of your database.

• How to: Add Management Scripts to a Database Project
  Describes how to add database management scripts (or any other non-deployment script) to your database project.

Related Sections

• Transact-SQL Editing Essentials
  Contains topics that describe the most important editing tasks that you can perform by using the T-SQL editor.

• Script Analysis and Execution in the Transact-SQL Editor
  Contains topics that help you analyze and run your scripts and queries in the T-SQL editor.

• Walkthrough: Deploy Changes to an Existing Version-controlled Database
  Explains how you deploy updates from a database project that is under version control to a database server.

• Terminology Overview of Team Edition for Database Professionals
  Describes terminology associated with the features of Team Edition for Database Professionals.