Can I use sqlbulkcopy with Azure SQL Paas?

azure-sql-database sqlbulkcopy sql-server

Question

Can I use sqlbulkcopy with Azure SQL Paas?

I have an app that does bulk copy to a database and we are testing it with SQL PaaS. It appears to be failing on the SQLBulkCopy.

I thought I read this is not supported somewhere but do not see it in the Azure SQL documentation. Is this still a limitation? Where is that documented?

I am using .net code to do the bulk copy (not SSIS or any other tool), it is a .net app, if it matters.

Accepted Answer

Short answer is, yes, you can use SQLBulkCopy to insert data from your .net app to SQL Azure.

However, if you have too much record you might face SQL Azure throttling issue.

Now, In case of CPU throttling SQL Database will not throw an error but will slowdown the operation and you will probably just get a timeout error. At this time there is no mechanism to determine whether this form of throttling is happening other than possibly looking at the query stats telling that the work is taking place slowly.

And if it is non-CPU throttling, then you will get an exception about it.

Also, if I recall correctly, there is a limitation for inserting bulk data into temp tables in SQL Azure, but it works for normal tables.




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why