Where can I find TableDiff.exe?

Not sure if you are running a 64bit OS as mine is located here:

C:\Program Files (x86)\Microsoft SQL Server\90\COM\tablediff.exe

On Windows with 64-bit SQL Server 2014, tablediff.exe is located here:

C:\Program Files\Microsoft SQL Server\120\COM\tablediff.exe

  • Replace 120 with 110 for SQL Server 2012, 100 for SQL Server 2008, etc.
  • For 32-bit version of SQL Server running on 64-bit Windows, replace Program Files with Program Files (x86)

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.


My Windows Search is broken, or I'm an idiot. I found it here:

C:\Program Files (x86)\Microsoft SQL Server\100\COM\tablediff.exe

and NOT here as expected:

C:\Program Files\Microsoft SQL Server\100\COM

Thanks guys!

Tags:

Sql Server