Bulk Load Files into SQL Azure?

azure bulkinsert azure-sql-database bcp
Snowy picture Snowy · Jun 15, 2011 · Viewed 19.6k times · Source

I have an ASP.NET app that takes multimegabyte file uploads, writes them to disk, and later MSSQL 2008 loads them with BCP.

I would like to move the whole thing to Azure, but since there are no "files" for BCP, can anyone comment on how to get bulk data from an Azure app into SQL Azure?

I did see http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx but am not sure if that applies.

Thanks.

Answer

Jeffrey Rosselle picture Jeffrey Rosselle · Nov 18, 2013

BCP is one way to do it.

This post explains it in three easy steps: Bulk insert with Azure SQL

Related questions

How to get the azure account tenant Id?

My question is: Is it possible to get the azure active directory tenant id without using powershell command? I found this two blogs and with this help, I'm already able to get the tenant ID and subscriptions ID from powershell. …

Read More
Install-Module : The term 'Install-Module' is not recognized as the name of a cmdlet

I was trying to install Azure using Install-Module Azure in PowerShell. I got the following error: PS C:\Windows\system32> Install-Module Azure Install-Module : The term 'Install-Module' is not recognized as the name of a cmdlet, function, script file, or …

Read More
Could not load file or assembly System.Web.Http.WebHost after published to Azure web site

I created a web project and it runs well in Visual studio. However, I got the following error after published it to azurewebsites. What can cause the issue? Could not load file or assembly 'System.Web.Http.WebHost, Version=5.0.0.0, Culture=…

Read More