Toad compares schema's nicely
"Chris Stamper" <cestamper_at_yahoo.com> wrote in message
news:34d76e21.0205061458.58d6868_at_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 Tue May 07 2002 - 09:09:06 CDT
