3

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 Answer 1

4

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.

Sign up to request clarification or add additional context in comments.

1 Comment

Looks like this is no longer the case with SQL Server 2017 in AWS, been discussing this at Reddit (reddit.com/r/aws/comments/8zbqvw/sql_server_2017_clr_support/…) with other users and have submitted a ticket for AWS to provide more info.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.