Openrowset On Linux

Kevin Feasel

2017-06-22

Linux

Steve Jones shows how to use the OPENROWSET command to bulk load data into SQL Server on Linux:

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows.

Linux is a slightly different beast. Once I started down this path, I had memories of working on SunOS in college, messing with permissions and moving files.

I run Ubuntu in VMWare, so I first downloaded the files to my Documents folder. That’s pretty easy. However, once there, the mssql user can’t read them. Rather than mess with permissions for my home, I decided to move these to a location where the mssql user could read them.

Much of the post is about file permissions.  This is because SQL on Linux is SQL on Windows, and that’s a glorious thing.

Related Posts

mssql-cli Update

Alan Yu announces an update to mssql-cli: GDPR compliance As many of us are familiar with, GDPR is approaching and we made some updates. In the past, file history stored entire T-SQL queries. However, if the query contained any secrets or passwords, it wasn’t smart enough to scrub those out. This is no longer the […]

Read More

SQL Server 2017 On Linux: The Azure VM Method

Kevin Feasel

2018-04-12

Linux

Prashanth Jayaram shows how to spin up an Azure VM running SQL Server 2017 on Linux: To create the VMs, you need to go through these four steps: Basics to configure basic setting of the VM Size to choose the VM machine size Settings to configure the features. In this case, the default values are […]

Read More

Categories

June 2017
MTWTFSS
« May Jul »
 1234
567891011
12131415161718
19202122232425
2627282930