Windows batch to loop through all sql files and call sqlcmd

andyabel · #1 (**permalink**) 01-27-11, 14:37

I need to write a Windows batch file to loop through all sql files in a directory and call sqlcmd.exe (the SQL Server 2008 command line). Something like this:-

(FOR %%i IN (*.sql) DO sqlcmd -S %1 -d %2 -E -i "%%i")

But I want to drop out of the loop if any of the calls to sqlcmd fails. But nothing I try seems to work. Hope you can help. Thanks.

LKBrwn_DBA · #2 (**permalink**) 01-28-11, 11:28

You could try something like this:

Code:

FOR %%i IN (*.sql) DO (
sqlcmd -S %1 -d %2 -E -i "%%i"
IF NOT ERRORLEVEL 0 GOTO :ERR
)
echo !Success. sqlcmd ok.
GOTO :EOP
:ERR
echo !Error. sqlcmd failed.
:EOP

Internet Services

Web Development

Digital Marketing

Consumer Tech