SQL Server CSV Export from Table or Query Data

In this article we will learn how to use ZappyShell Command Line Tools for SQL Server CSV Export from Table or Query result

ZappyShell for DB can export your SQL Server data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data in overwite or append mode. You can specify header, escape sequence, qualifiers and some other advanced options for CSV export.

Download here. Now Lets check how to do this.

Now next step is we need to Download and Install ZappyShell Command Line tools from hereYou can Download MSI Installer or XCopy Zip file which you can simply extract and copy (see below).

ZappyShell Command Line Tools – Export CSV, Excel, JSON, PDF

Sample ADO.net Connection String (No driver needed)

Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;
Data Source=localhost;Initial Catalog=Northwind;User Id=user1;Password=somepwd123;

Sample ODBC Connection String (SQL Native Client Driver)

Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Driver={SQL Server Native Client 11.0};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;
Dsn=mydsn;Uid=myUsername;Pwd=myPassword;

Sample OLEDB Connection String (SQL Native Client Driver)

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

More connection strings found here

Sometimes you may have need to split large amount of data into multiple files. With ZappyShell command line you can split data three different ways. Lets check each example.

SQL Server CSV Export – Split By Row Count

c:\tools>db.exe export customers --out c:\data\cust.csv --split --splitrows 1000 --connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

SQL Server CSV Export – Split By File Size

c:\tools>db.exe export customers --out c:\data\cust.csv --split --splitsize 10MB --connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

SQL Server CSV Export – Split By Group By Column

In this example we have exported customers in to separate file by country.

c:\tools>db.exe export customers --out c:\data\cust.csv --groupby Country --connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

SQL Server CSV Export – Table to CSV, Split files by Country Column

If you want to output compressed CSV (GZIP format) then use below command.

c:\tools>db.exe export customers --out c:\data\cust.csv --gzip --connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

If you want to use date time place holders in file name so it automatically uses specified date time parts use below command simply putting specifiers in file name anywhere.

c:\tools>db.exe export customers --out c:\data\cust_{{YYYY}}_{{MM}}_{{DD}}_{{HH24}}{{MI}}{{SS}}.csv --connstr "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI;"

• Download ZappyShell