Geek Answers Handbook

Does SQL Azure support or do not support CLR assemblies?

We have a couple of local dbs, and we see if we can transfer them to SQL Azure. Some of these dbs have a couple of custom functions written in C # in assembly (SAFE). After starting the search, I found a couple of messages that contradict each other. Some say v12 supports CLR code. Others say no. So here are my questions:

  • Does V12 support clr build embedding?
  • How can we export the script generation for azure using assembly? Whenever we set the export option to azure, we get an error saying that user-defined functions defined by the user are not supported in the azure area.

Thanks guys!

Louis

+9
sql-server sqlclr azure
source share
2 answers

CLR features are not supported in Azure:

Check here:

Differences between Azure SQL Transact-SQL Databases

In unsupported features, he mentions the integration of the .NET Framework CLR with SQL Server

I believe that there may be some confusion as to whether it supports or does not support them, as it was in one version, after which they removed support.

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

The latest news, literally: SQL CLR support removed from Azure SQL DB

+9
source share

Azure SQL now supports the CLR using a managed Azure SQL instance. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-transact-sql-information#clr

0
source share

More articles:


All Articles