database version control question

From: Nhuan_at_Lieu_NoSpam.org <Nhuan_at_Lieu.org>
Date: 2000/04/04
Message-ID: <8cbev6$c94$1_at_nnrp1.deja.com>#1/1


Hi, I am relatively new DBA, in your opinion what is your suggestion in handling version controlling database changes from Development->QA->Production in an environment where the several developing teams have multiple and/or independent database change requests to the _same_ database at _different_ timeframe. Below is a typical example:
DEV_TEAM1 have Table1 (increase a column size) & StoreProcedure1 update request and change priority is Important (not Emergency). This request to move into Production in 2 weeks. However, before the above change took place, DEV_TEAM2 request an "unrelated" functional change Emergency request to update Table1 (add an NULLable column) & StoreProcedure2. This second is to move into Production in 1 week. To summarize, Request 2 comes to DBA after Request 1 but need to move into Production sooner than Request 1 with one common & unrelated table change. To make it even worst, we have 7 such outstanding and similiar requests right now on the queue and I need to way to keep track of these changes as to minimuize impact.
Any systematic way to help to manage this chaos is highly appreciated and would like hear from you on your person experience how you did your change management.
Thanks.
PS - I works in a startup where change requests occur weekly.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 04 2000 - 00:00:00 CEST

Original text of this message