question

GakharVikas-7779 avatar image
0 Votes"
GakharVikas-7779 asked KalyanChanumolu-MSFT answered

Unable to install external assembly or use aggregate function in Azure SQL Database

Hi All,

I am trying to install external assembly in Azure SQL database (not a managed instance). I am unable to find any source or process to install external assembly.
Also, I have tried creating a User defined aggregate function but that functionality is also not available in Azure SQL Database.

Request support from community if anyone has created user defined aggregate function or installed external assembly(CLR Function) in Azure SQL Database(not a managed instance).

Do we have any timeline if Microsoft will be providing this service to Azure SQL database in near future or if there is any workaround for this?

Thanks in advance!!

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered GakharVikas-7779 commented

See CREATE ASSEMBLY (Transact-SQL) => Important => Azure SQL Database does not support creating an assembly from a file.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your comment. I am aware that this is not supported.
My question is -
Do we have any timeline if Microsoft will be providing this service to Azure SQL database in near future or if there is any workaround for this?
If we have any workaround for this feature/service or if we have any information that this feature/service will be added in near future by Microsoft.

0 Votes 0 ·
KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered

@GakharVikas-7779 Welcome to Microsoft Q&A Forums.

There is no timeline as of now for supporting external assemblies on Azure SQL Database.
If you need to use external assemblies, I suggest you consider Managed Instance

As for the workaround, many customers reuse their existing assemblies in Azure Functions and trigger them on a schedule to perform the business logic on Azure SQL Database.

Do let us know if you have further questions.


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.