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

MSF for CMMI Process Improvement

Go Search
Home
  
MSF for CMMI Process Improvement > Wiki Pages > Activity - Verify Database Project  

Activity - Verify Database Project

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 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

ResponsibleDatabase Administrator

Attributes

Element Categories[CMMI Track 2] Planning, [CMMI Level 3] VER SP 3.1, [CMMI Level 3] VER SP 3.2
Entry Criteria
Build and Deploy Setting Configured:
The default build and deploy settings are configured.

Generated Scripts Modified:
The generated scripts are modified.
Exit Criteria
Database Project Verified:
The database project is verified on a sandbox server and is ready to be used by developers.
Is RequiredYes

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.

Predecessors

TypeNameDependency Type
Modify Generated ScriptsFinish-Start

Successors

TypeNameDependency Type
Add Database Project to Source ControlFinish-Start

Last modified at 12/19/2007 10:37 AM  by Administrator