How to execute a file.sql (script) and save the results in a file in my computer using CMD (SQLCMD)?

Question

I need to run a script saved in my computer through CMD (SQLCMD) and save the result in other file in my computer.

If that's what you need to do, what's stopping you? What have you tried so far and why didn't it work? If you've not tried anything, why not? What research did you perform instead and what about it didn't you understand? If you tell us we can help explain it in more simple terms or with further examples. (Also, I recommend using PowerShell over CMD now, especially in a Windows 10 environment, where CMD doesn't really exist anymore.) — Thom A, Apr 24 '19 at 16:56

score 2 · Answer 1 · answered Apr 24 '19 at 16:38

Use SQLCMD to run a script from command line, see:

To save output to a file, look into using pipes for your output, see:

or

score 1 · Answer 2 · answered Apr 24 '19 at 16:41

1

You can run the script and then create another backup.

You can try mssql-scripter that is a multiplatform SQL command line tools such as sqlcmd.

answered Apr 24 '19 at 16:41

Kevin Hernández

score 0 · Answer 3 · answered Apr 24 '19 at 16:40

0

Use bcp
bcp "SELECT * FROM TABLE" queryout file.csv -t";" -SSERVERNAME -T -c -e errors.txt

answered Apr 24 '19 at 16:40

Alex M

3 Answers3