Skip to main content

MSF for Agile Software Development

Go Search
Home
  
MSF for Agile Software Development > Wiki Pages > WorkDefinition - Implement a Database Development Task  

WorkDefinition - Implement a Database Development Task

WorkDefinition Information

Implement a Database Development Task

Description

A database development task is a small piece of development work that stems from a quality of service requirement or scenario. Implementing a database development task involves adding the appropriate new functionality to the system. Once the database development task has been completed, it must be unit tested, reviewed, integrated, and checked into the existing code base. The scenario or quality of service requirement is then passed on to test. The isolated iterative database development process described here encourages agility in your data tier. This is achieved primarily through the use of an isolated database project and local development database for allowing database updates to be made locally. Most importantly, these changes can be tested in isolation using an automated unit test suite to ensure no regressions have occurred. The database thus goes through a testing loop with every change. As you can see, all changes are always immediately deployed to your sandbox database and tested there immediately. Only after this has been done will this change be available to be deployed to a production server, thus mitigating the risks of unmanaged database changes. At the same time, agility is achieved through tight collaboration with the application development team. Through the use of development tasks, team members can efficiently collaborate to achieve their shared development goals.

Write Code for a Database Development TaskUpdate Local Project EnvironmentPerform a Database Unit TestReview Database CodeCost a Database Development TaskRefactor Database CodeIntegrate Database Code Changes

Attributes

Element Categories[Agile Track 3] Build
GuidanceDatabase Unit Testing, Iterative Database Development, Managing Your Database With the Database Project System
Entry Criteria
The database project is created.

The database development task is created from a requirement work item.
Exit Criteria
The functionality described in the database development task is fully implemented.

Inputs and Outputs

WorkProductInputOutputAllowable States
Changeset(none)
Code(none)
TaskActive
Unit Test(none)

Predecessors

TypeNameDependency Type
Create a Database ProjectFinish-Start

Successors

TypeNameDependency Type
Deploy a Database ProjectFinish-Start

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