Re: Comparing 2 tables ... how ?

Hi,
There's a product put out Embarcadaro called DBArtisan Change Manager. which may deal with your problem.Among other things it claims to allow you to compare 2 or more schema, perform impact analysis and (optionally) synchronize them..

Hopefully this can be an option for you.

Hth,
Steve

In article <3a0a7252.79237348_at_news.telepac.pt>,   coreto03_at_axa-seguros.pt (Rui Anastácio) wrote:
>
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 10 2000 - 12:49:06 CST