Skip to main content

MSF for Agile Software Development

Go Search
Home
  
MSF for Agile Software Development > Wiki Pages > WorkDefinition - Create a Database Project  

WorkDefinition - Create a Database Project

WorkDefinition Information

Create a Database Project

Description

The create a database project workstream involves creating the initial database project for use by the development team. This crucial workflow sets up an offline representation of the database under development that can be shared by the whole team through source code control. Creating this project enables isolated iterative database development to occur among the database developers in a fashion that encourages change through mitigating the associated risks. This workstream’s activities include creating, configuring, and testing the database project. Oftentimes you will have an existing database that you wish to bring under a managed change environment and thus an important optional step is importing the existing live database into a database project. The activity of importing an existing database requires sufficient permissions on the database and thus is the responsibility of the database administrator, who has appropriate access to the live database environment. The Database Project Wizard can be used to guide you through most of the associated activities described below. This project wizard simplifies the creation of the database project. Further configuration may still need to be performed after completing the wizard. 

Verify Database ProjectModify Generated ScriptsImport Existing DatabaseConfigure Build and Deploy SettingsAdd Database Project to Source ControlCreate Database Project

Attributes

GuidanceHandling Security Objects
Entry Criteria
The task to create a database project is assigned.
Exit Criteria
The database project has been created, checked in to source control, and is ready to be synchronized locally by developers.

Inputs and Outputs

WorkProductInputOutputAllowable States
Code(none)
TaskNew, Active, Closed

Successors

TypeNameDependency Type
Implement a Database Development TaskFinish-Start

Last modified at 12/10/2007 3:34 PM  by Administrator