Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where can I find TableDiff.exe?

Tags:

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.

like image 531
Petrus Theron Avatar asked Oct 07 '10 11:10

Petrus Theron


People also ask

Where is Tablediff located?

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.

What is SQL utility table?

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.


1 Answers

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.

like image 66
Brett Veenstra Avatar answered Nov 16 '22 12:11

Brett Veenstra