Re: Database Comparison Script/Tool

Hi,

I posted a reply to your message but changed the subject so it was appearing as a separate thread, so reposting...

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:
> "Nancy Wells" <nancy_b_wells_at_hotmail.com> wrote:
> >
> > 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?
> >
>
> You might also like to try a google search for 'oracompare'
> I use that as well as the TOAD DBA schema compare, depending on
> circumstances.
>
> Regards,
> Paul

Thanks for the suggestion. I downloaded it and started the comparison. It may take a while before it completes.

Anyway this tool looks like it will compare only schemas. Our requirement is to compare 2 Oracle Apps databases which have many schemas. All we have is the apps password whi has permissions to access all the schemas. I may be wrong. Will oracompare do the job?

I also checked out dbdiff. The shareware version is highly restricted. compares only 5 objects of each type. Full version is a bit costly ($300 or more) for our needs. Just a one time usgae for just structural changes, not data changes. If nothing else works out we may go for this.

I also checked out dbcompare. cost only $10. Needs a ODBC connection. Can somone tell me what a ODBC connection string to an Oracle database will look like?

TIA,
N Wells Received on Wed Nov 27 2002 - 06:35:37 CST