{"id":9690,"date":"2025-03-14T08:22:34","date_gmt":"2025-03-14T08:22:34","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=9690"},"modified":"2025-03-14T09:22:34","modified_gmt":"2025-03-14T09:22:34","slug":"append-csv-data-to-sql-server-table-via-command-line-on-linux","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssql-cmd\/append-csv-data-to-sql-server-table-via-command-line-on-linux.html","title":{"rendered":"Append CSV data to SQL Server table via command line on Linux"},"content":{"rendered":"

Want to append the data from CSV<\/a> file to the existing SQL Server<\/a> table via command line on Linux (Ubuntu\/RedHat\/CentOS…)?<\/p>\n

Using mssql-cmd<\/a>, a Command-Line client for SQL Server, you can append CSV\/TSV\/TXT data into existing SQL Server table easily and fast.<\/p>\n

Support Windows, Linux, and MacOS.<\/p>\n

Download mssql-cmd Linux version<\/a> \"Download<\/a>
\nmssql-cmd.linux-386.zip<\/a>
\nmssql-cmd.linux-amd64.zip<\/a>
\nmssql-cmd.linux-arm64.zip<\/a>
\n<\/span><\/p>\n

No need to install SQL Server client library.<\/p>\n

Convenient to deploy to cloud. No need to run installation file, just uncompress and run, immediately.<\/p>\n

Append CSV\/TSV\/TXT data to existing SQL Server table via command line on Linux<\/h2>\n

1. In interactive mode:<\/p>\n

\nmssql-cmd> load loadtype=append\n      > table=media_messages \n      > datafile=\/data\/media_messages.csv \n      > delimiter=, \n      > quote=\" \n      > header=y;\n<\/pre>\n
2. In batch mode:<\/p>\n
\nmssql-cmd dsn=\"pan:withdata@192.168.0.102\/test\" task=load loadtype=append table=media_messages datafile=\/data\/media_messages.csv  delimiter=, quote=\" header=y quit=y\n<\/pre>\n
See parameters detail<\/a>.<\/p>\n
\n
More about mssql-cmd<\/a> – Command-Line client for SQL Server<\/a><\/p>\n
\n
Download mssql-cmd Linux version\"Download<\/a> 
\nmssql-cmd.linux-386.zip<\/a>
\nmssql-cmd.linux-amd64.zip<\/a>
\nmssql-cmd.linux-arm64.zip<\/a>
\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Want to append the data from CSV file to the existing SQL Server table via command line on Linux (Ubuntu\/RedHat\/CentOS…)? Using mssql-cmd, a Command-Line client for SQL Server, you can append CSV\/TSV\/TXT data into existing SQL Server table easily and fast. Support Windows, Linux, and MacOS. Download mssql-cmd Linux version mssql-cmd.linux-386.zip mssql-cmd.linux-amd64.zip mssql-cmd.linux-arm64.zip No need […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2556],"tags":[2557,73,34,2553,1321,2560],"class_list":["post-9690","post","type-post","status-publish","format-standard","hentry","category-mssql-cmd","tag-append","tag-command-line","tag-csv","tag-linux","tag-sql-server","tag-sql-server-append-csv"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=9690"}],"version-history":[{"count":4,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9690\/revisions"}],"predecessor-version":[{"id":27295,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9690\/revisions\/27295"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=9690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=9690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=9690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}