SQL Server: running every sql script in a directory

Question

I'm running SQL Server 2008 locally. I have a pile of scripts I would like to run on my local database. I can connect to the server and run them manually but I have over a 100 scripts, and I'm sure there is a way to do this. Any help is appreciated, thanks!

There's got to be a gazillion of those utilities out there!! Search on Google or Bing - you'll find tons of hits.... e.g. download.cnet.com/SQL-Batch-Executor/3000-10254_4-10385995.html or softpedia.com/get/Internet/Servers/Database-Utils/… or MANY MANY MORE — marc_s
– marc_s, Commented Apr 13, 2012 at 8:35

Mehmet Osmanoglu · Accepted Answer · 2012-04-13 08:27:32Z

3

You can iterate all query files in a directory and execute them with osql utility.

@echo off
for %%f in (*.sql) do (
    echo executing %%f
    osql -E -i %%f
)

pause

answered Apr 13, 2012 at 8:27

Mehmet Osmanoglu

1,21215 silver badges23 bronze badges

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

1 Comment

marc_s Over a year ago

As of SQL Server 2005, I would recommend using sqlcmd.exe instead of osql - but other than that - good answer

Collectives™ on Stack Overflow

SQL Server: running every sql script in a directory

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related