Is there a UI based way to load csv data to Azure SQL Database?

Question

I'm trying to figure out the easiest way to load data into an Azure SQL Database. I'm aware of all the methods referenced here , here and here as well as various ETL tools. By far, it looks like bcp using SSMS is the easiest way. My question is, is there an easier UI based way to load data from a file into a table, either via a bucket(blob storage) or directly uploaded like we can in Google BigQuery or AWS RedShift or Athena or Glue?

score 2 · Accepted Answer · edited Sep 19 '20 at 07:29

Please try the Azure Data Factory Copy Data tool as explained here.

1.On the Let's get started page, select the Copy Data tile to launch the Copy Data tool.

2.On the Properties page, under Task name, enter CopyFromBlobToSqlPipeline. Then select Next. The Data Factory UI creates a pipeline with the specified task name.

3.On the Source data store page, complete the following steps:

3a. Click + Create new connection to add a connection

3b. Select Azure Blob Storage from the gallery, and then select Next.

3c. On the New Linked Service page, select your storage account from the Storage account name list, and then select Finish.

3d. Select the newly created linked service as source, then click Next.

4.On the Choose the input file or folder page, complete the following steps:

4a. Click Browse to navigate file, then click Choose.

4b. Click Next to move to next step.

5.On the File format settings page, notice that the tool automatically detects the column and row delimiters. Select Next. You also can preview data and view the schema of the input data on this page.

6.On the Destination data store page, completes the following steps:

6a. Click + Create new connection to add a connection

6b. Select Azure SQL Database from the gallery, and then select Next.

6c. On the New Linked Service page, select your server name and DB name from the dropdown list, and specify the username and password, then select Finish.

6d. Select the newly created linked service as sink, then click Next.

7.On the Table mapping page, select the table, and then select Next.

9.On the Settings page, select Next.

10.On the Summary page, review the settings, and then select Next.

score 1 · Answer 2 · answered May 02 '19 at 19:18

1

It looks like all the methods you sited are the only ones currently supported, Data Factory is not a UI based solution but could possibly be easy, more information about it can be found here

answered May 02 '19 at 19:18

Adam Smith - Microsoft Azure

2,495
2
12
24

score 1 · Answer 3 · answered May 03 '19 at 02:00

I think you can use the Import Wizard with SSMS. It can help you import the csv file into the table most directly.

Here's the Exporting Data from SQL Azure: Import/Export Wizard

Here is how to import from SQL Azure:

In SQL Server Management Studio, connect to your Azure SQL database.
Right click on that database and choose from the drop down context menu Tasks | Import Data.
Choose a data Source: Azure Blob Source.
Choose a Destination: SQL Server Native Client 11.0.