Upsert data from CSV to SQL Server table via command line on Linux

Want to upsert data from CSV file to existing SQL Server table via command line on Linux (Ubuntu/RedHat/CentOS…)?

Using mssql-cmd, you can upsert(merge) CSV/TSV/TXT data to SQL Server table easily and fast, no need to program.

Here you can download mssql-cmd Linux version.

No need to install SQL Server client library.

Convenient to deploy to cloud. No need to run installation file, just uncompress and run, immediately.

Upsert/Merge CSV/TSV/TXT data into SQL Server table via command line on Linux

1. In interactive mode:

mssql-cmd> load loadtype=upsert
      > updatekey=id
      > table=media_messages 
      > datafile=/data/media_messages.csv 
      > delimiter=, 
      > quote=" 
      > header=y;

2. In batch mode:

mssql-cmd dsn="pan:withdata@192.168.0.102/test" task=load loadtype=upsert updatekey=id table=media_messages datafile=/data/media_messages.csv delimiter=, quote=" header=y quit=y

“loadtype=upsert” will update row in table if “updatekey” id exists, or insert new row.

See parameters detail.

More about mssql-cmd – the tool to upsert CSV/TSV/TXT data to SQL Server table via command line on Windows/Linux/MacOS