Comparing 2 tables ... how ?

From: Rui Anastácio <coreto03_at_axa-seguros.pt>
Date: Thu, 09 Nov 2000 09:52:17 GMT
Message-ID: <3a0a7252.79237348@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 Thu Nov 09 2000 - 03:52:17 CST