MSF for Agile Software Development Visual Studio 2005 Team System logo

Activity:

Create Database Project

Participating Roles

Responsible:

Database Administrator

Overview

Entry Criteria

  • The task to establish a database project has been created and assigned.

Sub-Activities

1

Review the Assigned Task

  • Review task work item currently assigned to you.
  • Understand the scope and requirements of the task.

2

Create a New Database Project

  • Decide which database project type you want to create: SQL Server 2000 or SQL Server 2005.
  • Use the appropriate project wizard template to guide you through the creation of your database project.

3

Configure Project Properties

  • Decide whether to organize your database project by object type or schema.
  • Configure schema defaults to use for creating new objects and for unqualified objects references.

4

Set Database Options

  • Configure database options, including appropriate SET options.
  • Set the appropriate database collation settings.

Exit Criteria

The database project is created.

© 2006 Microsoft Corporation. All rights reserved.

Version 4.1.0