How to execute the SQL Script through Batch Script Command from SQL?

Question

I am trying to execute the .sql file from batch script, but not able to execute. Script has multiple scripts such as Create Table , Stored Procedure separated by GO statement.

I tried with the below script, however script was not executed.

DB Servername : localhost\SQL2017
Authentication : Windows

sqlcmd -E -S localhost\SQL2017\MyDatabase -i C:\SQLScripts\TestScript.sql

Razvan Socol · Accepted Answer · 2019-07-07 14:51:11Z

1

Try this instead:

sqlcmd -E -S localhost\SQL2017 -d MyDatabase -i C:\SQLScripts\TestScript.sql

You need to use the -d parameter to specify the database name. The -S parameter should contain only the server name and the instance.

answered Jul 7, 2019 at 14:51

Razvan Socol

5,7492 gold badges22 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

How to execute the SQL Script through Batch Script Command from SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related