Search code examples
sqlsql-serverbatch-filesql-scripts

How to run multiple SQL scripts using a batch file?

I have a case where i have got 10+ SQL script.

I don't want to go and run all my scripts 1 by 1.

Is there a way that i can run all my scripts in succession in SQL Management studio.

I found this post. Creating a batch file seems easier.

This is all you need:

@echo off
ECHO %USERNAME% started the batch process at %TIME%  >output.txt


for %%f in (*.sql) do (
 (
sqlcmd.exe  -S servername -E   -d databasename -i %%f >>output.txt
)


pause

Replacing servername and databasename, but it seems to be not working.

Any ideas?

Solution

  • You can create a Strored Procedure to call all your Scripts. You could also create a schedule plan to run the scripts automaticaly.

    http://msdn.microsoft.com/en-us/library/aa174792(v=sql.80).aspx