Where can I find TableDiff.exe?

Question

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.

SQL Server 2008 is version 10.0 not 9.0, so it would be ...\Microsoft SQL Server\100\COM\... — P Daddy, Oct 07 '10 at 12:15
Thanks, I realised that - found it in C:\Program Files x86\... — Petrus Theron, Oct 07 '10 at 12:36

score 29 · Answer 1 · answered Oct 11 '10 at 21:04

29

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.

answered Oct 11 '10 at 21:04

Brett Veenstra

47,674
18
70
86

score 11 · Accepted Answer · answered Oct 07 '10 at 12:35

11

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!

answered Oct 07 '10 at 12:35

Petrus Theron

27,855
36
153
287

6

I am so sticking with `dir tablediff.exe /s` from now on. – Petrus Theron Oct 07 '10 at 12:37
4

Yup, Windows Search is crap. I always use `dir /s` these days. – P Daddy Oct 07 '10 at 12:38
@FreshCode I've been using dir but never of /s. Thanks – fiberOptics Feb 14 '12 at 09:41
When I need to find something on my Windows computer, I use Everything. It's amazing and really fast https://www.voidtools.com/downloads/ – Alf47 Feb 21 '18 at 13:57

score 4 · Answer 3 · edited Apr 05 '19 at 20:38

4

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

edited Apr 05 '19 at 20:38

MarredCheese

17,541
8
92
91

answered Oct 07 '10 at 12:09

Kane

16,471
11
61
86

I looked there - that folder is just filled with a bunch of DLLs. But I am running a 64-bit machine...let me look deeper. – Petrus Theron Oct 07 '10 at 12:33
As per Svein Fidjestøl's comment below, if you're running 64bit SQL Server, it'll be in C:\Program Files\, not C:\Program Files (x86)\ – Frank Tzanabetis Feb 11 '16 at 23:27

score 3 · Answer 4 · answered Oct 07 '15 at 08:54

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)

score 2 · Answer 5 · answered Nov 22 '16 at 14:53

2

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

answered Nov 22 '16 at 14:53

Afazal

542
5
9

score 1 · Answer 6 · answered Jan 30 '20 at 18:42

1

I found it by this path

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

answered Jan 30 '20 at 18:42

Artem Beziazychnyi

550
6
15

score 0 · Answer 7 · answered May 21 '21 at 09:40

0

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.

answered May 21 '21 at 09:40

Peter Vramby

1

Hey Peter, this was covered by [another answer](https://stackoverflow.com/a/3909963/6530134) already. – Timothy G. May 22 '21 at 20:34

Where can I find TableDiff.exe?

7 Answers7