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 - Update Local Project Environment  

Activity - Update Local Project Environment

View All Site Content

Recent Changes
Activity Information

Update Local Project Environment

Implement a Database Development TaskUpdate Local Project Environment

Description

Before beginning work on the development task, the developer must appropriately setup the local database project environment. This involves first syncing from the source control system the desired version of the project. Then the database project must be built and deployed to a sandbox server. This serves as a local isolated environment that the developer can use in order to test each and every modification made to the database project prior to checking it back into the source control system and eventually being deployed.

Roles

ResponsibleDatabase Developer

Attributes

Element Categories[CMMI Cycle 4] Iteration, [CMMI Track 3] Build, [CMMI Level 3] VER SP 1.2
Entry Criteria
Database Project Environment:
The database project environment is established.
Exit Criteria
Local Project Environment Established:
The database for the project is established.
Is RequiredYes

Steps

  1. Synchronize Database Project From Source Code Control to Desired Version:

    Identify the appropriate version of the database project to be synchronized.

    Synchronize the database project to this desired version from the source control system.
  2. Determine Sandbox Server:

    You must identify which database server will serve as your sandbox server.

    You can choose to use a local instance of SQL Server on your computer as the sandbox server. This will allow you to iteratively deploy database changes to an isolated environment only used by yourself.

    You can alternatively choose to use a shared computer running SQL Server as your sandbox server, but with a database unique to you on that server. This allows you to use a shared server, while still having an isolated environment for testing your database changes separate from other database developers.

    Either configuration is appropriate as long as the chosen sandbox database is unique to you and not shared by other database developers.
  3. Build Database Project:

    Ensure database project build settings are appropriately configured to target your sandbox server.

    Build the database project.

    Review and fix any build errors identified.
  4. Deploy Database Project to Sandbox Server:

    Deploy database project to sandbox server.

    Ensure deployment is successful by browsing deployed database.

Predecessors

TypeNameDependency Type
Cost a Database Development TaskFinish-Start

Successors

TypeNameDependency Type
Write Code for a Database Development TaskFinish-Start

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