The tablediff Command-Line Utility

The tablediff utility enables you to compare the contents of two tables. It was originally developed for replication scenarios to help troubleshoot non-convergence, but it is also useful in other scenarios. When data in two tables should be the same or similar, this tool can help determine whether they are the same, and if they are different, it can identify which data in the tables are different.

The syntax for tablediff is as follows:

Click here to view code image

tablediff[ -? ] |{        -sourceserver source_server_name[\instance_name]        -sourcedatabase source_database        -sourcetable source_table_name    [ -sourceschema source_schema_name ]    [ -sourcepassword source_password ]    [ -sourceuser ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial