CODEWITHSUNDEEP
sql-server
Petrus Theron
Petrus Theron

Reputation: 28856

Where can I find TableDiff.exe?

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.

Upvotes: 22

Views: 21947

Answers (7)

Peter Vramby
Peter Vramby

Reputation: 1

You can only find the tablediff.exe application back if you have choses the "SQL Server Replication" feature (Instance Features/Database Engine Services/SQL Server Replication).

I had a few servers where this feature was not installed and then you don't find the executable back.

Upvotes: 0

Artem Beziazychnyi
Artem Beziazychnyi

Reputation: 599

I found it by this path 

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

Upvotes: 1

Kane
Kane

Reputation: 16812

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

Upvotes: 4

Afazal
Afazal

Reputation: 542

tablediff.exe is self defined, if you did not find in your machine, look at someone else machine and grab the exe.

Upvotes: 2

Svein Fidjestøl
Svein Fidjestøl

Reputation: 3216

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)

Upvotes: 3

Brett Veenstra
Brett Veenstra

Reputation: 48514

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.

Upvotes: 29

Petrus Theron
Petrus Theron

Reputation: 28856

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!

Upvotes: 11

Related Questions