Re: Schema comparison tool
- From: "David Ballester" <ballester.david@xxxxxxxxx>
- To: mary_mcneely@xxxxxxxxx
- Date: Fri, 7 Nov 2008 17:35:47 +0100
2008/11/7 Mary Elizabeth McNeely <mary_mcneely@xxxxxxxxx>
> 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
>
>
ad nauseam :)
http://forums.oracle.com/forums/thread.jspa?threadID=359526
http://www.dbspecialists.com/files/scripts/compare_schemas.sql
I usually use this script, had made some changes but I must talk with the
developer to get grant to made it public ( if I can, under GPL )
Regards
D.
Other related posts:
