• I"d suggest either getting a tool like Red Gate Data Compare or ApexSQL Data Diff. There are several other vendors that have similar tools. If you can't do that take a look at the tablediff utility that comes with SQL Server (I think you need to install replication tools to get it).