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.
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
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!
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.