The specified option 'clr enabled' is not supported by Azure SQL Edge

user_2861595 0
Viewed 1100

I'm a .NET developer and new to mac (m1 pro). I use docker and pull the azure-sql-edge image. When I try to create a table with a geometry column or insert a value in the geometry type column that was generated by code first solution, I encounter the error below:

Common Language Runtime(CLR) is not enabled on this instance.

I tried to enable CLR by running exec sp_configure 'clr enabled',1, but encountered the error below:

The specified option 'clr enabled' is not supported by this edition of SQL Server and cannot be changed using sp_configure.

What to do? Please help me.

azure-sql-edge sqlclr apple-m1 macos sql-server
1 Answers

CLR-based functionality — whether it be the instance-level "CLR Integration" option (which enables custom / user-created assemblies); data types geometry, geography, and hierarchyid; built-in functions such as COMPRESS, DECOMPRESS, FORMAT, AT TIMEZONE; or a few other features — are not available in Azure SQL Edge. There is no way around this (at least not at this time). If any of this functionality is required, then using Azure SQL Edge as a platform is not an option. (Yeah, it kinda sucks, but that's how it goes.)

P.S. The CLR-based data types and built-in functions are not controlled via sp_configure 'clr enabled'. If they are available on the platform, then they cannot be disabled (outside of enabling fiber-mode / lightweight pooling, which is not something anyone should do).

user_5777650
Related