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

Home -> Community -> Usenet -> c.d.o.server -> Looking for tool to syncronize schemas--or advice on speeding up change manager

Looking for tool to syncronize schemas--or advice on speeding up change manager

From: Chris Stamper <cestamper_at_yahoo.com>
Date: 6 May 2002 15:58:11 -0700
Message-ID: <34d76e21.0205061458.58d6868@posting.google.com>


I work at a development site where, probably like most, we have many schemas floating around in different states. I need a tool that can take a baseline from one schema and generate the sql needed to bring other schemas into line--object structure-wise, not data.

I have tried OEM's Change Manager. It has the right idea, but it is so dang darn diddly arn slow, and it keeps pooping out after a few hours. The benchmark schema has about 2600 objects, 360-some are tables, lots of indexes, and about a zillion triggers, constraints, sequences and little stuff. We have our own home-grown scripts that can syncronize two schemas in about 4 hours. I was hoping the world of tool development could have done better.

Any suggestions or recommendations would be appreciated. Received on Mon May 06 2002 - 17:58:11 CDT

Original text of this message

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