DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool.
DBC can compares the schema of two Microsoft SQL Server databases and quickly locates the differences in tables, views, stored procedures or any other object in the database(even included Service Broker) .

Compare data between different SQL Server databases and tables.It supports user defined key specification as well as Primary key or unique key
DBC support mssql2000, mssql2005, mssql2008 (future)

It can identify the difference between the two databases, including the table, view view, storage process stored procedures (including Remote Service Binding), and simultaneous analysis of the script for the implementation of sync.

The license of this software is Free Trial Software, the price is $199.00, you can free download and get a free trial.