The tablediff utility is used to compare the data in two tables for non-convergence, and is particularly useful for troubleshooting non-convergence in a replication topology. This utility can be used from the command prompt or in a batch file to perform the following tasks:
- A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replication Publisher and the destination table at one or more instances of SQL Server acting as replication Subscribers.
- Perform a fast comparison by only comparing row counts and schema.
- Perform column-level comparisons.
- Generate a Transact-SQL script to fix discrepancies at the destination server to bring the source and destination tables into convergence.
- Log results to an output file or into a table in the destination database.
Many of us would have used this tool. The only boring and time consuming point with this tool is that it's a command-line based tool and it's hard to type those long commands again and again. Now here is a little utility that's a very simple user interface that acts as a driver for this utility. Below is a screen-shot of the same.
Article 
No comments:
Post a Comment