Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Looking for tool to syncronize schemas--or advice on speeding up change manager
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
![]() |
![]() |