Re: Schema comparison tool
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: ballester.david@xxxxxxxxx
- Date: Fri, 7 Nov 2008 11:38:50 -0500
change management pack of oem?
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Consultant
Nationwide Investments
Data Engineering and Administration
(Work) 614-677-1668
614-312-6715
From:
"David Ballester" <ballester.david@xxxxxxxxx>
To:
mary_mcneely@xxxxxxxxx
Cc:
oracle-l@xxxxxxxxxxxxx
Date:
11/07/2008 11:37 AM
Subject:
Re: Schema comparison tool
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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:
