RE: Schema comparison tool
- From: Yavor Ivanov <Yavor_Ivanov@xxxxxxxx>
- To: "mary_mcneely@xxxxxxxxx" <mary_mcneely@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Nov 2008 12:01:56 +0200
"PL/SQL developer" is quite good at that. I use it all the time.
But it is not free.
Regards,
Yavor Ivanov
Oracle Certified Master
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mary Elizabeth McNeely
Sent: Friday, November 07, 2008 1:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Schema comparison tool
Good afternoon, all,
I seek your opinions/experiences about tools that can compare two Oracle
schemas (or the same schema on two databases) and make a report of the
differences. Ideally, it would also create the SQL needed to resolve those
differences: create indexes (or indices, if you will), add columns, recreate
views, etc.
I know TOAD has such a tool, but it's proven ineffective for us, as it
generates many false positives, especially when one schema is an imported copy
of the other - that makes for subtle capitalization/double quote differences in
stored SQL, plus other troubles. Physical clones don't have these differences,
but we mainly want to compare imported schemas for divergence from their parent
schemas.
Thanks in advance for whatever advice you have to offer.
Kind regards,
Mary Elizabeth McNeely
Purveyor of Trouble
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
