Re: Database Comparison Script/Tool

In TOAD (from www.quest.com) there is a "compare schemas" option. It does a good job. It makes a list of objects that differ, exist in one but not the other and vice versa and even builds a script to correct all the difference. Without the DBA option you can only view it on screen and print it. With the DBA option you can save these files.

There was a free version of TOAD and I think it is still there but I could not find it quickly on Quests website (they hide it very well, they want to sell the real product). In my older version there is a limited "schema differences" option.

Nancy Wells <nancy_b_wells_at_hotmail.com> schreef in berichtnieuws 1f14c0b1.0211232146.f064cd8_at_posting.google.com...
| Hi,
|
| We are starting on the impact analysis of migrating custom code from
| an Oracle Apps 11.5.4 database to a 11.5.8 database.
|
| Before we start we want to find out all the data model changes between
| the two databases. We want a list of all data objects (tables/synonyms
| etc) and views, that are unchanged between the two versions, a list of
| all new data objects + views, a list of all data objects that have
| been changed and the exact changes (column additions, deletions and
| column definition changes).
|
| Is there a good tool available to do that? Does anyone have any
| scripts to do that?
|
| Thanks in advance.
|
| Regards,
| N Wells
Received on Sun Nov 24 2002 - 04:00:14 CST