I have 2 database with mulitple tables. These are suppose to be identical (ie: backup)

What way would be the most efficient to compare 2 tables to make sure that all fields in each record is the same in both tables.

Thank you in advance for suggestions to accomplish this.