sqlt-sqlbatch-filedos

DOS command to execute all SQL script in a directory and subdirectories


I need a DOS command or a batch (.bat) file I can execute to run all the *.sql scripts in a directory and its subdirectories. What would the solution be?


Solution

  • The following will get you started

    for /r %f in (*.sql) do echo %f
    

    Run from the command line that will print the names of all the SQL files in the current directory and all sub directories.

    Then substitute sqlcmd <connection args> -i%f for echo %f to execute the scripts.

    Hope this helps.