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
    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
    Jul 21, 2014 at 12:26
  • 2
    I think it's because SQL client driver still on 110 version
    – gmsantos
    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
    Aug 13, 2015 at 13:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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