db diff tool
I was asked to perform validation if migration from postgres 8.3 to 9.02 didn't brake anything in our db schema and data. I have to find tool to do that because of db size. I have found tool for performing diffs on db schema (apgdiff), but still I don't have tool for data diff. As a alternate way I would like to compare two xmls(db xml dump), but also I can't find anything free.
Have you ever done anything similar?
Re: db diff tool
I don't know Postgres, but it seems unlikely that upgrading your database version would cause a loss in data.
If Postgres supports it, you might consider using the MINUS operator. See: http://techonthenet.com/sql/minus.php
If you are looking for exact comparisons, WinMerge can compare XML files well.