Re: Comparasion of mutliple databases

In article <35FA66DB.67AE2892_at_vision-consulting.com>,   Rob Nield <rnield_at_vision-consulting.com> wrote:
> Hello all,
>
> I would like to produce an object comparasion report between three
> different databases, you know produciton, test , development .........
> Do any of you know any SQL scripts or programs that would enable me to
> do this please.
>
> Thanks for you help
> Bob.
>
>

I'd start by looking at the ALL_OBJECTS table for each database. First pass, send the object names to files and run the UNIX diff command. (If not using UNIX, use the perl language.) Unfortunately there is no Oracle command to do this. PERL is a good way to solve this, even on NT. If ALL_OBJECTS shows too many differences, then you may have to refine the initial query for just the objects you are interested in. The alternative queries would select from USER_TABLES, USER_INDEXES, USER_CONSTRAINTS, etc. I'm assuming you want to find which objects exist in one database and not in the others. That's how you have to start. Then you can find the differences between objects of the same name that exist is two or more of the databases. You just need to build the queries and scripts up for each level of comparison.

(Blantant ad: my firm is working on a differences tool in PL/SQL.   Let me know if you are interested. End ad)

I hope this helps. Ask again when you begin writing the scripts and we can help in more detail.

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 08:03:50 CDT