Try this tool(its freeware):
Aseem Gautam
2010-10-23 14:57:55
+5
A:
A few options:
Use one of the redgate products.
Write a script to do a full outer join between each of the tables you want to compare, with comparison logic. Include system tables to check your structure etc is the same
Script/query the database and the data, then do a text comparison.
Rory
2010-10-23 14:59:47
+1 for Red Gate products
AdaTheDev
2010-10-23 15:11:18
A:
http://www.red-gate.com/products/SQL_Data_Compare/index.htm for data http://www.red-gate.com/products/SQL_Compare/index.htm for schema
pastafarian
2010-10-23 15:09:10