MSF for Agile Software Development Visual Studio 2005 Team System logo
workstreams icon

Create a Database Project

Database Administrator

Participating Roles

Responsible:

Database Administrator

Overview

Entry Criteria

  • The task to create a database project is assigned.

Activities

1

Create Database Project

  • Review the assigned task.
  • Create a new database project.
  • Configure project properties.
  • Set database options.

2

Import Existing Database

  • Optional
  • Import an existing database schema into the database project.

3

Configure Build and Deploy Settings

  • Specify the target server that will serve as the sandbox server.
  • Configure deployment options.

4

Modify Generated Scripts

  • Modify pre-deployment script.
  • Modify post-deployment script.

5

Verify Database Project

  • Build database project.
  • Deploy database project to sandbox server.

6

Add Database Project to Source Control

  • Add database project to source control system.
  • Check in project.
  • Resolve work item

Exit Criteria

The database project has been created, checked in to source control, and is ready to be synchronized locally by developers.

© 2006 Microsoft Corporation. All rights reserved.

Version 4.1.0