Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server CLR stored procedures in AWS

I have 2 SQL Server CLR stored procedures and we are moving database server to AWS.

I would like to know if those CLR stored procedures will work after move to AWS?

Can use SQL Server CLR stored procedures in AWS? do I need to do anything special? or maybe I need to rewrite them to T-SQL?

like image 981
Wojciech Avatar asked Mar 18 '26 11:03

Wojciech


1 Answers

After additional research I found that it is possible to have SQL Server CLR stored procedures in AWS

In the David Iffland article How To Use SQL CLR in Amazon AWS RDS there is step by step instruction how to do it.

There is an improvement on the new version of AWS DB Parameter Group and it just require changing changing the flag clr enabled to 1.

like image 99
Wojciech Avatar answered Mar 20 '26 03:03

Wojciech