sqlcmd with output file and screen output

Question

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:

Yes, the script works suscefull, it's not an issue question.
And yes, I've a "print "something" on my sql. The log file gets the output.

Thanks a lot!

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

If the log isn't too big, you could always add a TYPE PROCESS.LOG to the BAT file before the Pause. Don't know if this will help and don't know of any way to get both file and screen output... — Sparky
– Sparky, Commented Feb 16, 2012 at 23:35

Gerardo Lima · Accepted Answer · 2012-04-24 18:07:56Z

3

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

answered Apr 24, 2012 at 18:07

Gerardo Lima

6,7613 gold badges34 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gerardo Lima Over a year ago

You can get more information about command redirection at this links link, link.

jgerstle · Accepted Answer · 2013-06-13 15:24:09Z

2

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

answered Jun 13, 2013 at 15:24

jgerstle

1,6847 gold badges25 silver badges35 bronze badges

Collectives™ on Stack Overflow

sqlcmd with output file and screen output

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related