I just found out about the TableDiff tool for SQL Server on the hidden features question and had a full-blown nerdgasm. I would like to download the tool, but everywhere I look I am told to look in C:\Program Files\Microsoft SQL Server\90\COM\TableDiff.exe
. After looking everywhere on my PC (I have SQL Server 2008 Express and SQL Server 2008 installed), I can't find it.
Where I can download the TableDiff.exe tool stand-alone?
The GUI tool isn't the droid I'm looking for.
You can find the tool in a version-specific subfolder of your SQL Server shared features installation directory. For example, look in C:\Program Files\Microsoft SQL Server\110\COM if you've got SQL 2012 installed on the C: drive.
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.
If you cannot find TableDiff.exe, re-run the SQL Server install and choose REPLICATION support.
TableDiff is officially "Microsoft (R) SQL Server Replication Diff Tool" and will be added when using Replication.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With