Dump tsql result to a file

Question

Id like to run mssql queries in a bash script with tsql command. Thats okay, i can connect and run manualy. I tried to save the result to a file with this script but no success.

> tsql -connection parameters- < tsql_input.sql > tsql_output.csv

where tsql_input.sql is :

select ... from .... ;

or

> tsql -connection parameters- < sql_cmd

where sql_cmd is :

echo "SELECT ... FROM ...;\n
GO\n
exit\n
" > out.csv

What did I miss ?

score 1 · Answer 1 · answered May 06 '16 at 13:22

1

Use bcp.exe https://msdn.microsoft.com/de-de/library/ms162802(v=sql.120).aspx

Sample: bcp.exe "SELECT Name FROM AdventureWorks.Sales.Currency" queryout Currency.Name.dat -T -c

answered May 06 '16 at 13:22

Frank

1,901
20
27

Thank you, but I need Debian to use it. – gszabo May 06 '16 at 13:24
Anything else ? :) – gszabo May 12 '16 at 12:34
look at that: http://stackoverflow.com/questions/17078869/how-to-run-a-sql-script-in-tsql – Frank May 13 '16 at 19:20

Dump tsql result to a file

1 Answers1