Re: DDL comparison, deployment and version management
Date: Tue, 05 Oct 2004 22:12:25 -0700
Message-ID: <1097039626.824421_at_yasure>
stevie wrote:
> 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
I can't think of a worse way to handle it.
Depending on what you are doing you could look at:
Change Management Packs
DataGuard
Advanced Replication
and by all means the DBMS_RECTIFIER_DIFF built-in package.
go to: http://www.psoug.org/
click on Morgan's Library
click on DBMS_RECTIFIER_DIFF
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Oct 06 2004 - 07:12:25 CEST