CODEWITHSUNDEEP
sqlsql-server-2005command-linesqlcmd
Leandro Bardelli
Leandro Bardelli

Reputation: 11608

sqlcmd with output file and screen output

I do some command line batch (.bat) with sqlcmd as this way:

sqlcmd -i Scripts\STEP01.sql -o PROCESS.log -S MYSERVER -E -d MYDATABASE

and i need an output file (it's works currently) and also the output trought the screen to do something like:

@echo off
echo The result of the query was:
    sqlcmd -i Scripts\STEP01.sql -o PROCESS.log -S MYSERVER -E -d MYDATABASE
pause
CHOICE /C:YN /M "Is the result accord?"
IF ERRORLEVEL 2 GOTO ENDWITHERROR
IF ERRORLEVEL 1 GOTO STEP2

Note:

Thanks a lot!

Similar question without answer: How to run a sql script file using sqlcmd and output to both shell and file

Upvotes: 6

Views: 26479

Answers (2)

jgerstle
jgerstle

Reputation: 1684

If you want you can use powershell instead and use the following:

sqlcmd -i Scripts\STEP01.sql  -S SERVER -E -d MYDB | Tee-Object -file "PROCESS.log"

More info from Microsoft

Upvotes: 2

Gerardo Lima
Gerardo Lima

Reputation: 6712

I also couldn't find a better way then @Sparky proposed. The following code adds his suggestion:

@echo off

:: this will execute the script into PROCESS.log
sqlcmd -i Scripts\STEP01.sql -o PROCESS.log -S MYSERVER -E -d MYDATABASE

:: this present the contents of PROCESS.log to the screen
echo The result of the query was:
type PROCESS.log

pause
CHOICE /C:YN /M "Is the result accord?"
IF ERRORLEVEL 2 GOTO ENDWITHERROR
IF ERRORLEVEL 1 GOTO STEP2

Upvotes: 2

Related Questions