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

Enterprise MSF Agile (with CobiT)

Go Search
Home
  
Enterprise MSF Agile (with CobiT) > Wiki Pages > Activity - Update Local Project Environment (Create a Quality of Service Requirement)  

Activity - Update Local Project Environment (Create a Quality of Service Requirement)

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

PerformerDatabase Developer

Attributes

CategoriesIteration, Build, MSF Agile Principles - Invest in Quality

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 1/17/2008 11:18 PM  by Administrator