Schema comparison tool

I use a tool called Modelright ( www.modelright.com ) and am very pleased with it.  

--

John Bossert

Data Architect

Hubspan, Inc.  

• Original Message ----

From: Mary Elizabeth McNeely <mary_mcneely_at_yahoo.com>

To: oracle-l_at_freelists.org

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

--

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 12 2008 - 11:27:46 CST