Re: Comparing 2 tables ... how ?

You could try something like

select a.*
from database1.table1 a, database2.table1 b where a.var1 <> b.var1 and

            a.var2 <> b.var2 and
            a.var3 <> b.var3 etc

but keep in mind this will be very i/o intensive

HTH "Rui Anastácio" <coreto03_at_axa-seguros.pt> wrote in message news:3a0a7252.79237348_at_news.telepac.pt...
>
> Hi !
>
> I need to compare 2 tables, one on database A and another on database
> B.
>
> Actually I need to compare many tables to see if the two databases
> are equal.
>
> I'm thinking in writing a script to export a table into a text file.
> Then I export all tables from DB A to DIR_A and from DB B to DIR_B.
> Then I write a Perl script to compare all files from these two dir's
> or just use some filesync program.
>
> Finally with some diff program check the differences between the
> files.
>
> QUESTIONS:
> How can I write an export script ? Does SELECT writes the
> lines in the same order on both DB's ? Can I use a diff program on
> that ?
>
> Is there any programs that can do this comparison ?
>
> Rui Anastácio
>
Received on Fri Nov 10 2000 - 09:26:15 CST