Here is an example command that compares two tables Table1 and Table2 in the same database.
"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe" -sourceserver server1 -sourcedatabase test -sourcetable table1 -destinationserver server1 -destinationdatabase test -destinationtable table2
When the command is run this is the output that you get:
Microsoft (R) SQL Server Replication Diff Tool Copyright (C) 1988-2005 Microsoft Corporation. All rights reserved.
User-specified agent parameter values: -sourceserver server1 -sourcedatabase test -sourcetable table1 -destinationserver server2 -destinationdatabase test -destinationtable table2
Table [test].[dbo].[table1] on server1 and Table [test].[dbo].[table2] on server1 have 3 differences. Err PersonID Mismatch 1 Dest. Only 2 Src. Only 3 The requested operation took 0.4375 seconds.
From this basic command we can see there are differences, but it is not very helpful as to what the problem is, so to make this more useful we can use the "-et" argument to see the differences in a table. The "et" parameter will create a table, in our case called "Difference", so we can see the differences in a table.
"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe" -sourceserver server1 -sourcedatabase test -sourcetable table1 -destinationserver server1 -destinationdatabase test -destinationtable table2 -et Difference
When we query the table "Difference" that was created we see the following results. As you can see this is not any more helpful then the first run.
