Skip to main content
Sign In |
  Help (new window)

MSF for CMMI Process Improvement

Go Search
Home
  
MSF for CMMI Process Improvement > Wiki Pages > Activity - Create Database Project  

Activity - Create Database Project

View All Site Content

Recent Changes
Activity Information

Create Database Project

Create a Database ProjectCreate Database Project

Description

The first step is to create the database project from the appropriate database project template. Various database project settings should also be configured at this time as they control the behavior of the project going forward.

Roles

ResponsibleDatabase Administrator

Attributes

Element Categories[CMMI Track 2] Planning, [CMMI Level 3] PI SP 1.2
Entry Criteria
Create Database Project Task Assigned:
The create a database project task is assigned.
Exit Criteria
Database Project Created:
The database project is created.
Is RequiredYes

Steps

  1. Review Assigned Task:

    Review the 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.

Inputs and Outputs

WorkProductInputOutputAllowable States
Task(none)

Successors

TypeNameDependency Type
Configure Build and Deploy SettingsFinish-Start
Import Existing DatabaseFinish-Start

Last modified at 12/19/2007 10:37 AM  by Administrator