Re: database change control and synching up 56 databases

From: Tim Gorman <tim_at_sagelogix.com>
Date: Fri, 09 Jul 2004 19:30:54 -0600
Message-ID: <BD14A2EE.18028%tim@sagelogix.com>

How about restores from backups?

No need for comparisons afterward, no worries about LONGs or types of partitioning, etc...

on 7/9/04 11:16 AM, ryan.gaffuri_at_comcast.net at ryan.gaffuri_at_comcast.net wrote:

> I just started a new project. We have 56 databases. This is between dev,test,
> and prod. This is not a distributed system so its just one application.
> Apparently many of them are not in synch.
> We are doing 4 releases at the same time. Release 4 will include changes that
> release 1 has however, all of these releases are in development at the same
> time. There is no repository or ERD.
> We need to find the best way to synch up the databases. Here are some methods.
> What have you done?
> 1. OEM -- apparently this works, but it takes about 90 minutes to compare two
> databases
> 2. Toad -- fast, but inaccurate. It fails on some views and packages.
> 3. Code -- We are considering doing a data extract to the file system and then
> using a script to diff everything.
> We have talked about using Designer, the problem is that this application is
> rather large and is already partially deployed. So to backward engineer it
> into designer would take a significant amount of time. Plus we are using hash
> partitioning which is not supported by designer, so we would need to do
> post-generation changes.
> Anyone have any experiences to share on how they managed this?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 09 2004 - 20:28:03 CDT