I am migrating SQL Server 2017 running from EC2 instance to AWS RDS SQL Server.

What would be the best approach to migrate logins with SIDS, passwords, server roles, and database roles? I know the easiest way is using Copy-DbaLogin tool from dbatools.io. However, RDS doesn't allow server level permission.

Appreciate anyone could share some thoughts and ideas based from experiences.

Thank you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.