MSF for Agile Software Development Visual Studio 2005 Team System logo

Activity:

Analyze Changes

Participating Roles

Responsible:

Database Administrator

Overview

Entry Criteria

  • The database unit tests are complete and, if applicable, bugs are fixed.

Sub-Activities

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.

Exit Criteria

The scope of changes made to the database are analyzed and understood.

© 2006 Microsoft Corporation. All rights reserved.

Version 4.1.0