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.