Bat File To execute SQL _ Scripts ".bat"

@echo off
set USERNAME=sa
set PASSWORD=password
set DB= Database
set SERVER=server


REM setlocal
REM SET SQLCMD=sqlcmd -S<servername\instancename> -d<database name> -E
REM for %%d in (*.sql) do %SQLCMD% -i%%d
REM endlocal


setlocal



SET SQLCMD=sqlcmd /S %SERVER% /U %USERNAME% /P "%PASSWORD%" /d %DB%
for %%d in (Tables\*.sql) do %SQLCMD% -i%%d -o%%d.log

SET SQLCMD=sqlcmd /S %SERVER% /U %USERNAME% /P "%PASSWORD%" /d %DB%
for %%d in (Data\*.sql) do %SQLCMD% -i%%d -o%%d.log

SET SQLCMD=sqlcmd /S %SERVER% /U %USERNAME% /P "%PASSWORD%" /d %DB%
for %%d in (SP\*.sql) do %SQLCMD% -i%%d -o%%d.log



endlocal


Pause