如何从SQL托管实例（PaaS）或SQL数据库（PaaS）访问blob？

本文介绍了如何从SQL托管实例（PaaS）或SQL数据库（PaaS）访问blob？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何从SQL托管实例（PaaS）或SQL数据库（PaaS）访问blob？

How to access a blob from a SQL Managed Instance (PaaS) or a SQL Database (PaaS)?

我们有许多需要在数据库上运行的SQL查询 这样做的最佳方法是什么，......这将是一个三步过程：下载文档，复制并运行查询，上传任何已编辑的查询，... 我们认为使用IaaS会更快，哪个会更快？ 我们是否使用来自IaaS的URI来访问blob，这只是将URI粘贴到浏览器中？ 如果不允许浏览器我们推荐其他什么方法？

We have many SQL queries that need to run on the databases. What would be the best method to do this,... would this be a three step process: download document, copy and run query, upload any edited query,... We are thinking it would be faster to use an IaaS which would a quicker process? Do we access the blob using the URI from a IaaS which is simply pasting the URI into a browser? If the browser is not allowed what other method would we recommend?

dsk

推荐答案

Microsoft Azure Blob存储服务的SQL Server集成支持始于SQL Server 2012 Service Pack 1 CU2增强功能，并且已通过SQL Server 2014和SQL Server 2016进一步增强。我建议检查以下 教程 w 包含所有要求的信息。如果有帮助，请告诉我。 谢谢，

SQL Server integration support for the Microsoft Azure Blob storage service began as a SQL Server 2012 Service Pack 1 CU2 enhancement, and has been enhanced further with SQL Server 2014 and SQL Server 2016. I'd recommend checking the following tutorialwhich includes all the requested information. Let me know if this helps. Thanks,

Adam