MSF for Agile Software Development Visual Studio 2005 Team System logo

Activity:

Verify Database Project

Participating Roles

Responsible:

Database Administrator

Overview

Entry Criteria

  • The default build and deploy settings are configured.
  • The generated scripts are appropriately modified.

Sub-Activities

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.

Exit Criteria

The database project is verified on a sandbox server and is ready to be used by developers.

© 2006 Microsoft Corporation. All rights reserved.

Version 4.1.0