Does or does not SQL Azure support CLR assemblies?

sql-server azure azure-sql-database sqlclr azure-sql-managed-instance
Luis Abreu picture Luis Abreu · May 20, 2016 · Viewed 11.9k times · Source

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:

  • Does V12 supports embedding clr assemblies?
  • How can we export the generation script for azure with the assembly? Whenever we set the export option to azure we end up getting an error saying that clr user defined functions are not supported in azure.

Thanks guys!

Luis

Answer

steoleary picture steoleary · May 20, 2016

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

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
How to view the roles and permissions granted to any database user in Azure SQL server instance?

Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance? I have this below query: SELECT r.name role_principal_name, …

Read More
How do I create a new user in a SQL Azure database?

I am trying to use the following template: -- ================================================= -- Create User as DBO template for SQL Azure Database -- ================================================= -- For login <login_name, sysname, login_name>, create a user in the database CREATE USER <user_…

Read More