Skip to main content

Enterprise MSF Agile (with CobiT)

Go Search
Home
  
Enterprise MSF Agile (with CobiT) > Wiki Pages > Activity - Write Code for a Database Development Task (Create a Quality of Service Requirement)  

Activity - Write Code for a Database Development Task (Create a Quality of Service Requirement)

Activity Information

Write Code for a Database Development Task

Description

The next step is to actually write the code associated with the database development task at hand. This may involve updating existing database schema objects or creating new ones. After each set of changes is made, the changes should be iteratively deployed to the sandbox server for testing.

Roles

PerformerDatabase Developer

Attributes

CategoriesIteration, Build, Check In

Steps

  1. Implement New or Update Existing Schema Objects:
    Add new schema objects if necessary.

    Implement new schema objects.

    Check out existing objects that need to be changed.

    Update existing schema objects if necessary.

  2. Build Database Project:
    Build the database project.

    Review and fix any build errors identified.

  3. Deploy Database Project to Sandbox Server:
    Deploy database project to sandbox server.

    Ensure deployment is successful by browsing deployed database.

Inputs and Outputs

WorkProductInputOutputAllowable States
Code(none)

Predecessors

TypeNameDependency Type
Update Local Project EnvironmentFinish-Start

Successors

TypeNameDependency Type
Perform a Database Unit TestFinish-Start

Last modified at 1/17/2008 11:18 PM  by Administrator