RE: Schema comparison tool
Date: Fri, 7 Nov 2008 09:30:49 -0600
Nearly every tool available as these same limitations. TOAD is as good as any that I have seen. I don't think there are many tools that will compare two schemas like this and give you the DDL to make them the same. OEM 9i used to do it, but 10g EM doesn't (go figure).
I have never been able to run the DDL right out of the box, however. I always just use it as a shortcut to make it quicker to make the scripts myself.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham Sent: Friday, November 07, 2008 2:02 AM
Subject: Re: Schema comparison tool
The dba module in Toad is very good I've been using it for years.
On 06/11/2008, Mary Elizabeth McNeely <mary_mcneely_at_yahoo.com> wrote:
> 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
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-l [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 07 2008 - 09:30:49 CST