sql-serverazureazure-sql-databasesqlclrazure-sql-managed-instance

Does or does not SQL Azure support CLR assemblies?


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:

Thanks guys!

Luis


Solution

  • CLR Functions are not supported in Azure:

    Check here:

    Azure SQL Database Transact-SQL differences

    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:

    Breaking News, Literally: SQL CLR Support Removed from Azure SQL DB