Till Date I have been using Red Gate SQL compare tool for Schema comparison for databases.
Just came to know Microsoft Visual Studio2010 also provides an inbuilt tool for Data comparison & Schema Comparison for two databases.
Below are the steps for the DB comparison :
On clicking the above a wizard would ask for back up files of the databases for the comparison. It will generate the difference report.
SQL Server Tips · · · ·
Not sure, but its only availabe in Premium and Ultimate editions, not there in professional edition
It is available in database edition.
I have checked in the Premium edition only. Not sure about other editions.