21

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?

  • 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 '14 at 9:36
26

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.

  • 1
    Thanks. Isn't it strange, that the folder is 110 for the 120 version? – Uwe Keim Jul 21 '14 at 12:26
  • 2
    I think it's because SQL client driver still on 110 version – gmsantos Jul 21 '14 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 '15 at 13:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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