我可以将sqlbulkcopy与Azure SQL Paas一起使用吗? [英] Can I use sqlbulkcopy with Azure SQL Paas?

问题描述

我可以在Azure SQL Paas中使用sqlbulkcopy吗?

Can I use sqlbulkcopy with Azure SQL Paas?

我有一个可以批量复制到数据库的应用程序，我们正在使用SQL PaaS对其进行测试.在SQLBulkCopy上似乎失败了.

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.

我以为我在某些地方不支持阅读此文件，但在Azure SQL文档中看不到它.这仍然是一个限制吗?在哪里记录?

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?

我正在使用.net代码进行批量复制(不是SSIS或任何其他工具)，如果需要的话，它是.net应用程序.

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

推荐答案

简单的答案是，是的，您可以使用SQLBulkCopy将.net应用程序中的数据插入SQL Azure.

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

但是，如果记录太多，则可能会遇到SQL Azure节流问题.

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

现在，在CPU进行节流的情况下，SQL数据库不会引发错误，但会减慢操作速度，您可能只会得到超时错误.目前，除了可能查看查询统计信息以表明工作进展缓慢之外，没有任何机制可以确定这种节流形式是否正在发生.

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.

如果它是非CPU节流的，那么您将得到一个例外.

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

此外，如果我没记错的话，在SQL Azure中将批量数据插入到临时表中有一个限制，但是它适用于普通表.

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.

这篇关于我可以将sqlbulkcopy与Azure SQL Paas一起使用吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！