I'm trying to do a column by column, row by row comparison for 75 tables in two different databases. The tables contain up to 165 million records.
I need to determine if there are any missing records, and we need to identify any columns that contain different values. Potential problems include decimal errors.
Thanks for any assistance or advice.