Azure SQL Database CLR functions are working
9
votes
3
answers
1069
views
I'm in the middle of migrating a database to Azure SQL Database. I was reading about the differences between Azure SQL Database and Azure Managed Instance and noticed that CLR functions are NOT supported in Azure SQL Database.
This surprised me as I've already loaded a test version of the database into Azure SQL Database and nobody complained about issues. I looked and sure enough, the CLR assembly is there and running queries that use the CLR functions work just fine.
So I went searching the web, and all the information I see is that CLR does not work with Azure SQL Database. Yet here I am, with a working CLR assembly in Azure SQL Database.
So now I'm wondering, do I tell the business we have to switch to use Managed Instance because that's the only place that CLR is supported? Or stick with Azure SQL Database because it's working fine? Or have I missed something? Did Microsoft re-enable CLR without telling anyone?
Asked by paulH
(1642 rep)
Sep 25, 2024, 09:18 AM
Last activity: Sep 27, 2024, 09:27 AM
Last activity: Sep 27, 2024, 09:27 AM