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?

回答1:

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.