I have a large amount of XML files that I transfer via ftp to an azure website folder on a daily basis. I currently use c# to transfer the data to azure sql server tables. However, it is extremely slow.
我有大量的XML文件,我每天通过ftp传输到azure网站文件夹。我目前使用c#将数据传输到azure sql server表。但是,它非常慢。
Is there a way I can run an Azure SQL job to bulk import these files and if so, how do I access the files in the web apps folder?
有没有办法运行Azure SQL作业来批量导入这些文件,如果是这样,我如何访问web apps文件夹中的文件?
I know how to do this on a standard SQL server with XML files residing on a share drive but am unsure how to do this in azure.
我知道如何在标准的SQL服务器上执行此操作,XML文件驻留在共享驱动器上但不确定如何在azure中执行此操作。
1 个解决方案
#1
0
Currently, we do not support any T-SQL interface to read files from blob store or container. So you have to push the data from outside of SQL Server.
目前,我们不支持任何T-SQL接口从blob存储或容器中读取文件。因此,您必须从SQL Server外部推送数据。
One option is to use Azure Automation to run your code periodically or based on a schedule. See post below on how to use Azure Automation:
一种选择是使用Azure自动化定期或基于计划运行代码。请参阅下面有关如何使用Azure自动化的帖子:
http://azure.microsoft.com/en-us/documentation/articles/automation-manage-sql-database/
#1
0
Currently, we do not support any T-SQL interface to read files from blob store or container. So you have to push the data from outside of SQL Server.
目前,我们不支持任何T-SQL接口从blob存储或容器中读取文件。因此,您必须从SQL Server外部推送数据。
One option is to use Azure Automation to run your code periodically or based on a schedule. See post below on how to use Azure Automation:
一种选择是使用Azure自动化定期或基于计划运行代码。请参阅下面有关如何使用Azure自动化的帖子:
http://azure.microsoft.com/en-us/documentation/articles/automation-manage-sql-database/