Skip to main content
Sign In |
  Help (new window)

Enterprise MSF Agile (with CobiT)

Go Search
Home
  
Enterprise MSF Agile (with CobiT) > Wiki Pages > Activity - Verify Database Project (Create a Quality of Service Requirement)  

Activity - Verify Database Project (Create a Quality of Service Requirement)

View All Site Content

Recent Changes
Activity Information

Verify Database Project

Create a Database ProjectVerify Database Project

Description

After the project has been appropriately configured, it is time to build and deploy it to your sandbox server to ensure that the project is ready to be used by developers. This step is crucial in uncovering configuration settings that have not been appropriately applied or missing pre-deployment or post-deployment scripts.

Roles

PerformerDatabase Administrator

Attributes

CategoriesPlan, MSF Agile Principles - Invest in Quality

Steps

  1. Build Database Project:
    Build the database project.

    Review and fix any build errors identified.

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

    Check the output window for any errors. Also, ensure deployment is successful by browsing to the deployed database.

    If you imported the database schema from an existing live database, you can use the schema comparison tool to verify the deployment by comparing the deployed database to the initial source database.

Inputs and Outputs

WorkProductInputOutputAllowable States
Code(none)

Predecessors

TypeNameDependency Type
Modify Generated ScriptsFinish-Start

Successors

TypeNameDependency Type
Add Database Project to Source ControlFinish-Start

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