in reply to Re: Comparing DBI records
in thread Comparing DBI records

I had a similar issue and solved it by using Array::Compare.

I grab the data from both databases as an arrayref, making sure the sequence of the fields is the same in both queries and then I throw the arrayrefs to the comparator of Array::Compare.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

My blog: Imperial Deltronics

In Section Seekers of Perl Wisdom