Extracting data from MS SQL server to CSV via batch file

Question

I need to write a batch file that will, among other things, connect to a MS SQL server and extract all the content of 3 tables (dbo.Group, dbo.Membership and dbo.Person) to 3 separate CSV files. The CSV files should be with headers (column names in the tables), semicolon separated and UTF-8.

The machine running the batch file will be Windows 10 or Server 2012, connecting to another server on the network running MS SQL Server.

Any ideas how to go about this?

Are you sure this needs to be fully contained in a batch file? You do have a SQL server... — Jacob H
– Jacob H, Commented Nov 22, 2017 at 13:32

Denis Rubashkin · Accepted Answer · 2017-11-22 13:48:35Z

1

Use sqlcmd Utility, for instance one command:

SQLCMD -S SERVER/INSTANCE -E -Q "SELECT * FROM Table1" -s ";" -o "C:\temp\file1.csv" -W

answered Nov 22, 2017 at 13:48

Denis Rubashkin

2,2311 gold badge11 silver badges16 bronze badges

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

3 Comments

Joachim Hollekim Over a year ago

That did it! I ran the script as you wrote, added -u to get unicode and it works very well. Only question is that "(103 rows affected)" was added to the end of the CSV file. Is there any way to avoid this?

Denis Rubashkin Over a year ago

I think, adding "set nocount on" to the beginning of your query will solve this problem

Matias Squartini Over a year ago

this works well but for some reason the output has a second row with ----- , -----,

Collectives™ on Stack Overflow

Extracting data from MS SQL server to CSV via batch file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related