SQL Azure是否支持CLR程序集? [英] Does or does not SQL Azure support CLR assemblies?

问题描述

我们有几个本地数据库，我们正在查看是否可以将它们迁移到SQL Azure.这些数据库中的一些具有在程序集(SAFE)中用C#编写的几个用户定义函数.运行搜索后，我发现了几条彼此矛盾的帖子.有人说v12支持CLR代码.其他人则说没有.所以，这是我的问题:

We've got a couple of on-premises dbs and we're seeing if we can migrate them to SQL Azure. Some of those dbs have a couple of user defined functions written in C# in an assembly (SAFE). After running a search, I've found a couple of posts which contradict each other. Some say that v12 supports CLR code. Others say it doesn't. So, here are my questions:

• V12是否支持嵌入clr程序集?
• 如何将装配的天蓝色脚本导出为生成脚本?每当我们将导出选项设置为azure时，最终都会收到一条错误消息，指出azure不支持clr用户定义的函数.

谢谢大家！

路易斯

推荐答案

Azure不支持CLR函数:

CLR Functions are not supported in Azure:

在这里检查:

Azure SQL Database Transact-SQL的区别

在不受支持的功能下，它提到".NET Framework CLR与SQL Server集成"

Under unsupported features it mentions ".NET Framework CLR integration with SQL Server"

我认为，是否像以前在一个版本中一样支持或不支持它们，然后他们取消了支持.

I believe there may be some confusion as to whether it does or doesn't support them as they used to in one version, then they removed support.

这里有一个链接，详细说明了它们受支持但被拉的事实，这显然是由于安全问题:

Here is a link detailing the fact they were supported, but got pulled, apparently due to a security issue:

从字面上看要令人震惊的消息:从Azure SQL DB中删除了SQL CLR支持

这篇关于SQL Azure是否支持CLR程序集?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！