Re: How to CM an Oracle DB

Mark <mso_at_doubled.com> wrote in article
<mso-2510972005560001_at_m188.doubled.com>...
> added groups:comp.software-eng,comp.databases,comp.databases.oracle.misc,
> comp.databases.oracle.tools
>
> In article <345218AF.9C6A62A8_at_mindspring.com>, Ron Perrella
> <perrella_at_mindspring.com> wrote:
>
> @
> @ You don't really CM the DB. You CM how to reconstruct the DB. In
> @ other words, you want reproducibility. So, CM the SQL scripts that
 build
> @ and populate the DB.
> @
> @ Gee did I use enough TLA? (Three-letter-acronyms)
> @
> @ -Ron
>
> Yes, I agree that is the goal. I think this is is possible to do based on
> the last project I was on (I came in to a established CM project
> environment where all DB changes where released with the software as
> scripts to be run). However, the DBA on our current project claims it is
> not possible and is "asinine" to think it can be done due to the
> complexities of the project. She also claims the DB scripts used in one
> environment (development) cannot be used in another environment (system
> test, production). I just want to be sure I am correct before I push the
> issue up the chain of command. In my original post, I was looking for
> published references that it can be done.
>
> Please see my reply to Ken MacLeod <ken_at_bitsko.slc.ut.us> "Re:How to CM
> Oracle DB (DBAs input requested)"
>
> Thanks,
>
> Mark
> mso_at_doubled.com
>

I am not a DBA, but I have done a lot (~10 years) of "databased" development. I have always dumped the schema (i.e., the SQL scripts to which you refer) and placed it under version control. Differences between "snapshots" of the schema are easy enough to see through the use of the "diff" utility included with every version control system I have used. The use of "patches" (e.g., "ALTER TABLE" SQL scripts, etc.) complicates things a bit, but the combination of a baseline plus "patches" should equal the latest "snapshot." It is really no different then controlling any other piece of source code.

Olen Vance Sluder, Jr. <olen_at_acm.org>
San Antonio, Texas Received on Sun Oct 26 1997 - 00:00:00 CDT