Skip to main content

MSF for Agile Software Development

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

WorkDefinition - Deploy a Database Project

WorkDefinition Information

Deploy a Database Project

Description

Every database project will eventually need to be deployed into a production environment. This workstream outlines how the database administrator should go about performing such a deployment through a managed, predictable process. This involves getting the appropriate version of the database project that will be deployed and verifying the database through build, deploy, and performing unit tests. The database administrator then needs to understand the changes that will be made and then modify the generated build script appropriately. Finally, the build script must be executed against the target server and the database verified.

Verify BuildDeploy Database to Staging ServerAnalyze ChangesDeploy DatabaseBack Up Target DatabasePerform Database Unit TestsSynchronize Database ProjectCreate Build Script

Attributes

GuidanceDeploying Your Database Project to Production, Handling Security Objects
Entry Criteria
Database project changes are checked in to source control system, ready for deployment.
Exit Criteria
Database project changes are successfully deployed to the target server.

Inputs and Outputs

WorkProductInputOutputAllowable States
Task(none)

Predecessors

TypeNameDependency Type
Implement a Database Development TaskFinish-Start

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