Batch file script for sqlcmd

Question

I'm looking for a way to make the below commands a bit more automated. I would like to be able to use just a simple batch file if possible.

sqlcmd /S localhost\SQLEXPRESS /U [dbusername] /P [dbpassword]

1> drop database datastore

2> go

When you read the help file for the SQLCMD did you not see the -i option? — Squashman
– Squashman, Commented Jul 17, 2018 at 12:00
Possible duplicate of Executing set of SQL queries using batch file? — Squashman
– Squashman, Commented Jul 17, 2018 at 12:09

Vincent Gheur · Accepted Answer · 2018-07-17 11:46:09Z

0

Have you tried this:

sqlcmd /S localhost\SQLEXPRESS /U [dbusername] /P [dbpassword] <cmds.txt

where cmds.txt is a file containing your commands (the drop and the go commands).

answered Jul 17, 2018 at 11:46

Vincent Gheur

517 bronze badges

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

1 Answer 1