24

Using "SQLCMD.EXE" to back up my SQL Server Express databases for years I just discovered that after installing the 2014 version, I found no SQLCMD.EXE anymore.

In previous versions it was located at

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE

But in my 2014 installation, no SQLCMD.EXE exists in

C:\Program Files\Microsoft SQL Server\120\Tools\Binn

My question:

Any chance to get SQLCMD.EXE into SQL Server Express 2014?

Improve this question
1
  • 1
    What happens when you type sqlcmd in command prompt. Does that gives error ? I have 2014 exprees on my PC will check and revert but my guess is some change has been made.
    – Shanky
    Commented Jul 21, 2014 at 9:36

1 Answer 1

Reset to default
28

Found this on Microsoft Connect:

According to this page on MSDN http://msdn.microsoft.com/en-us/library/ms143547(v=sql.120).aspx , sqlcmd.exe and bcp.exe are now in < Install Directory >\Client SDK\ODBC\110\Tools\Binn

Indeed, sqlcmd.exe and bcp.exe are in that folder in my machine.

Make sure you installed Client SDK Tools.

Improve this answer
3
  • 1
    Thanks. Isn't it strange, that the folder is 110 for the 120 version?
    – Uwe Keim
    Commented Jul 21, 2014 at 12:26
  • 2
    I think it's because SQL client driver still on 110 version
    – gmsantos
    Commented Jul 21, 2014 at 12:34
  • 2
    The logical way to find it is now to check the "ODBCToolsPath" registry key, as mentioned in another post within the Microsoft Connect issue.
    – Tony Wall
    Commented Aug 13, 2015 at 13:08

Not the answer you're looking for? Browse other questions tagged or ask your own question.