Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
450 views
Welcome To Ask or Share your Answers For Others

1 Answer

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...