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 - Deploy Database to Staging Server (Create a Quality of Service Requirement)  

Activity - Deploy Database to Staging Server (Create a Quality of Service Requirement)

View All Site Content

Recent Changes
Activity Information

Deploy Database to Staging Server

Deploy a Database ProjectDeploy Database to Staging Server

Description

Optionally you may wish to test the deployment on a staging server prior to deploying to the production server. Here you follow the same steps as if you were doing the actual deployment - execute the deploy script and verify the results.

Roles

PerformerDatabase Administrator

Attributes

CategoriesDeploy

Steps

  1. Execute Build Script Against Staging Server (Optional):
    Execute the build script against the staging server in the T-SQL editor to ensure that the deployment will succeed on this server prior to deployment to the target server.

    Analyze any failures that occur.

  2. Use Schema Compare to Verify Deployment (Optional):
    Create schema comparison sessions to view the differences between the project and the staging server.

    Ensure no unknown differences exist between the two databases. Known differences include objects that are defined in pre-deployment or post-deployment scripts, because these objects will not appear as part of the schema comparison. Rules and defaults are examples of such objects.

Predecessors

TypeNameDependency Type
Back Up Target DatabaseFinish-Start

Successors

TypeNameDependency Type
Deploy DatabaseFinish-Start

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