I have been checking out Redgate's SQL Data Compare, a neat tool that saves you a lot of time coding the comparison manually. Basically it lets you compare the data in two tables in different database to see what is the same and what is different.
Read more →