Monday, March 21, 2011

Execute .SQL Script

If you want to execute a sql script without SQL Management Studio, you can use SQLCMD.exe.

"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\sqlcmd.exe" -i MySQLScript.sql

This allowed me to write a deploy.bat file which creates and fills all my required databases.

No comments:

Post a Comment