Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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
up vote 21 down vote accepted

Found this on Microsoft Connect:

According to this page on MSDN , 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.

share|improve this answer
Thanks. Isn't it strange, that the folder is 110 for the 120 version? – Uwe Keim Jul 21 '14 at 12:26
I think it's because SQL client driver still on 110 version – gmsantos Jul 21 '14 at 12:34
The logical way to find it is now to check the "ODBCToolsPath" registry key, as mentioned in another post within the Microsoft Connect issue. – Code Chief Aug 13 '15 at 13:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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