Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: DDL comparison, deployment and version management

Re: DDL comparison, deployment and version management

From: Hans <forbrich_at_gmail.com>
Date: 5 Oct 2004 10:13:58 -0700
Message-ID: <bd0e88c6.0410050913.24be6d6f@posting.google.com>


steviehaston_at_hotmail.com (stevie) wrote in message news:<4092f6be.0410050244.3973d2aa_at_posting.google.com>...
> Hi
> We are attempting to manage changes to schemas on a variety of
> different instances of Oracle by enforcing a procedure where each
> change is scripted by a single individual and managed by our source
> control system. These scripts are then manually executed in the
> correct order during a release. This works OK but is becoming unwieldy
> when we have ever more instances to manage, especially when branching
> application code means branching database structure.
> I was wondering if there are alternative ways of handling this and/or
> best practices that others have experience of.
> I presume there are DDL (and data) comparison tools that can be used
> which can simplify the complexitiy of this process - does anyone have
> good/bad experiences with these tools?
> Thanks for your input
> Stevie

One alternative is to use the 'Change Management Pack' add-on to Oracle Enterprise Manager. Received on Tue Oct 05 2004 - 12:13:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US