CODEWITHSUNDEEP
sql-serverazureazure-sql-databaseazure-cosmosdb
Aditya Prasad
Aditya Prasad

Reputation: 222

How to Call Webservice/CLR functions from Azure SQL

Im using SQL Server 2016. My DB contains Web service calls and .net Assemblies incorporated (CLR Functions). I'm planning to move my DB to Azure SQL. Is it possible to call Webservices/CLR functions from Azure SQL? I see this article says its not possible. Is there any update/other way around?

How does Cosmos DB support support w.r.to this scenario? Please Suggest

Upvotes: 0

Views: 1074

Answers (2)

Alberto Morillo
Alberto Morillo

Reputation: 15688

You cannot use CLR functions on Azure SQL Database but you can use CLR functions on an Azure Managed Instance with some restrictions. Managed Instance cannot access file shares and Windows folders, so the following constraints apply:

  • Only CREATE ASSEMBLY FROM BINARY is supported.
  • CREATE ASSEMBLY FROM FILE is not supported.
  • ALTER ASSEMBLY cannot reference files.

To learn about Azure Managed Instances, please visit this documentation.

Upvotes: 1

Conor Cunningham MSFT
Conor Cunningham MSFT

Reputation: 4501

SQL Azure does not support CLR in-database. However, SQL Azure Managed Instance does. So, please look into that option.

Your other possible approach is to consider what logic exists in CLR and see if you can move to T-SQL equivalents. Since CLR was added, we now have batch mode processing (Columnstore) as well as in-memory tables/natively compiled stored procedures. Both options are pretty fast alternatives that may solve your problem. In-memory tables are supported on SQL Azure with >= 1 core due to associated memory requirements. Columnstore works on S3 and above in Standard and on Premium/V-core options.

Upvotes: 1

Related Questions