Re: comparing 3 tables from 3 databases

Mark Bole <makbo_at_pacbell.net> wrote in message news:<pBeTc.4316$tN6.2713_at_newssvr27.news.prodigy.com>...
> Shawn wrote:
> >>>>We have 3 databases. Each of these databases have a identical table.
> >>>>Each table has anywhere from
> >>>>1400-1550 records. The data in these tables was supposed to be
> >>>>identical. But they aren't.
> >>>>So, I need to compare the table in each database to determine the
> >>>>exact differences of the data.
> >>>>Any suggestions on how to best complete this task would be greatly
> >>>>appreciated!
> >>>>
> >>>>Thanks,
> >>>>Shawn
> >>>>
> >>>
> [...]
> >
> > What if the databases aren't linked? Each database represents
> > separate/distinct financial activity and I think they keep them apart for
> > audit reasons?
> >
> > Thanks,
> > Shawn
> >
> >
>
> If the databases aren't linked in real time, then make a copy. As
> previously mentioned, you can't compare if you can't access.
>
> Also, consider the supplied package DBMS_RECTIFIER_DIFF as an
> alternative to MINUS operator.
>
> --Mark Bole

PERL with the DBI package is great for this. It's exactly analogous to what I did on my previous contract, compare address data in three systems. Multiple connections open simultaneously, lots of PERL comparison features (pattern matching), and file system access (for generating reports or correction scripts).

Ed Received on Mon Aug 16 2004 - 13:05:08 CDT