>I am looking for a good utility that can compare two tables (from different DB's) and identify any differences in the data. (One that also looked at structural differences would be a plus!)
>
>Thanks
>
>doug
I doubt if such a utility exists. It'd be extremely difficult to do. You'd have to establish criteria as to which fields to compare with each other. Further, the order in which they were compared would also be a factor.
Structural differences, however, might be easier. I'd look at either the AFIELDS() function or COPY STRUCTURE EXTENDED as a starting point.
George
Ubi caritas et amor, deus ibi est