Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
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 at 9:36

1 Answer 1

up vote 6 down vote accepted

Found it 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 this folder at 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 at 12:26
2  
I think it's because SQL client driver still on 110 version –  gmsantos Jul 21 at 12:34

Your Answer

 
discard

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.