从Azure SQL调用Web服务的最佳方法是什么? [英] What is the best approach to call web service from azure sql?

问题描述

从Azure SQL(从存储过程)调用Web服务的最佳方法是什么? 我了解Azure SQL不支持CLR程序集(SQLCLR).

What is the best approach to call web service from azure sql(from stored procedure)? I understand that azure sql doesn't support CLR assemblies(SQLCLR).

推荐答案

否，您不能从Azure SQL数据库访问外部资源(网络，文件系统，注册表等).在该平台上，SQLCLR和OLE Automation存储过程(即sp_OA*)均不可用.即使在Azure SQL数据库支持SQLCLR的一年半中(2014年末至2016年4月中旬)，也仅是SAFE程序集，而这些程序不能进行外部操作.

No, you cannot access external resources (network, file system, registry, etc) from Azure SQL Database. Neither SQLCLR nor OLE Automation stored procedures (i.e. sp_OA*) are available on that platform. Even during the year-and-a-half that Azure SQL Database supported SQLCLR (late 2014 through mid-April 2016), it was SAFE Assemblies only, and those can not do external operations.

您唯一的选择是在Azure SQL数据库之外处理此问题，或使用加载有SQL Server的Azure VM(Express Edition是免费的，因此您只需要为Azure VM本身付费，这可能是一项费用，有效选项).

Your only option is to handle this outside of Azure SQL Database, or use an Azure VM with SQL Server loaded on it (Express Edition is free, so you would only pay for the Azure VM itself, which might be a cost-effective option).

这篇关于从Azure SQL调用Web服务的最佳方法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！