Schema comparison tool
- From: "John Bossert" <john.bossert@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Nov 2008 09:27:46 -0800
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@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
--
------------------------------
Other related posts:
