Batch file for executing SQL Script from specified Folder

REM ******************************************************************

REM ** Batch File : Database_Desing_Procedures.Bat

REM ** Purpose : This batch file is used to deploy all the sql Procedures into the specified database

REM ** Author : Vasanth Thangasamy

REM ** Written Date: 17-Apr-2007

REM ** Version : 1.0

REM ******************************************************************

@echo off

setlocal

dir/b /on *.sql >tmp.lst

REM ******************************************************************

REM *** Put your Server name, Database name and login credential ***

set ServerName=HCL-SV74QJMEZMB\SQLEXPRESS

set DataBaseName=Universal

set Login=sa

set Password=DigitalServer

REM ******************************************************************

MD C:\DBLongs\Universal

set Connection=Sqlcmd -S %ServerName% -E -d %DataBaseName%

for /F %%i in (tmp.lst) do %Connection% -i %%i -o C:\DBLongs\Universal\%%i%.txt

endlocal

goto :eof