Executing .SQL file from cmd

Question

i want to execute a .sql file from cmd. Here's my command :

sqlcmd -e -S "(localdb)\myDB" -i "C:\PathToMyFile\File.sql" -U user -P password

Here's my errors :

Microsoft ODBC Driver 13.1 is installed. Someone knows what I've done wrong? Thx.

can you go to sql server configuration manager and make sure SQL Server (MSSQLSERVER) is running? in addition: stackoverflow.com/questions/30953100/… — Eray Balkanli
– Eray Balkanli, Commented Feb 6, 2018 at 19:57
It's never a good idea to post an image of your errors. You'll do much better here to put the error text here, even if you have to re-type it. — Joel Coehoorn
– Joel Coehoorn, Commented Feb 6, 2018 at 20:19
@ErayBalkanli Lot's of people will never see that image or choose not to bother with it. Using an image instead of text limits the number of people who might have helped you. — Joel Coehoorn
– Joel Coehoorn, Commented Feb 6, 2018 at 20:38
It also won't come up in google searches, so the overall quality of StackOverflow as a resource is lower. — Greg Viers
– Greg Viers, Commented Feb 6, 2018 at 21:05

ErikEJ · Accepted Answer · 2018-02-07 06:43:51Z

2

You are using the wrong server name:

sqlcmd -e -S "(localdb)\mssqllocaldb" -d MyDB -i "C:\PathToMyFile\File.sql" -U user -P password

or with Integrated Authentication:

sqlcmd -e -S "(localdb)\mssqllocaldb" -d MyDB -i "C:\PathToMyFile\File.sql" -E

answered Feb 7, 2018 at 6:43

ErikEJ

42.1k5 gold badges82 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yea that's it ! Thx :)