Table schema comparison and sometimes data too!
Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish by using information_schema views (easy way).
There are third party tools available such as SQLCompare & DataCompare that are very popular in the market, also you can take help of CSDiff by scripting the database to a file and use this tool.
So for this specific unit test and data comparison exercise tasks Microsoft is coming with a new tool DBPro by blending Team Edition for DB professionals. For more information on Team Foundation Server refer to thisDownload link. To wrapup don't forget to look into TableDiff.Exe that is available with SQL Server, more from here in this case.