Re: Schema comparison tool
- From: "Lou Fangxin" <anysql@xxxxxxxxx>
- To: ecpdba97@xxxxxxxxx
- Date: Fri, 7 Nov 2008 15:11:31 +0800
ocidiff is free of use.
On Fri, Nov 7, 2008 at 9:09 AM, Frank Pettinato <ecpdba97@xxxxxxxxx> wrote:
> This is the best tool I have ever used for that and it's cheap!
>
> TOYS - www.impacttoys.com
>
> hth,
> Frank
>
> ------------------------------
> *From:* Robert Freeman <robertgfreeman@xxxxxxxxx>
> *To:* mary_mcneely@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Sent:* Thursday, November 6, 2008 5:26:36 PM
> *Subject:* Re: Schema comparison tool
>
> If you are running 11g you could look at the dbms_comparison PL/SQL
> package.
>
> RF
>
> Robert G. Freeman
> Author:
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> Other various titles out of print now...
> Blog: http://robertgfreeman.blogspot.com
> The LDS Church is looking for DBA's. You do have to be a Church member in
> good standing. A lot of kind people write me, concerned I may be breaking
> the law by saying you have to be a Church member. It's legal I promise! :-)
>
>
>
> ----- Original Message ----
> From: Mary Elizabeth McNeely <mary_mcneely@xxxxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx
> Sent: Thursday, November 6, 2008 4:55:45 PM
> 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
>
>
>
>
--
Welcome!
http://www.AnySQL.net/en
Other related posts:
