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 - Analyze Changes (Create a Quality of Service Requirement)  

Activity - Analyze Changes (Create a Quality of Service Requirement)

View All Site Content

Recent Changes
Activity Information

Analyze Changes

Deploy a Database ProjectAnalyze Changes

Description

It is important for the database administrator to understand what exactly is the scope of changes that are about to be deployed to the database server. The database administrator can determine this by both looking at the source control change history since last deployment as well as doing a schema compare between the project and live database.

Roles

PerformerDatabase Administrator

Attributes

CategoriesDeploy

Steps

  1. Review Source Control Change History Since Last Deployment:

    Use the source control history to view all changes that have occurred in the database project since last deployment.

     

    Contact specific developers about changes that you were not aware of and want to understand further prior to deployment.

  2. Use Schema Compare to Analyze Differences Between the Project and the Target Server:

    Create a schema comparison session to compare the database project to the target server.

     

    Analyze all differences found to ensure they are what you expected.

  3. Review the Refactoring Log Files:

    Review the refactoring log files associated with the database project to understand all the database refactorings that have occurred since the last database deployment.

Predecessors

TypeNameDependency Type
Perform Database Unit TestsFinish-Start

Successors

TypeNameDependency Type
Create Build ScriptFinish-Start

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