AWS Database Blog
Author: Ramesh Babu Donti
Ramesh Babu Donti is a Delivery Consultant with AWS Professional Services in Hyderabad, India. He specializes in designing and implementing highly available applications and database solutions on AWS, with extensive experience in enterprise application migrations, database migration and modernization, and GenAI solutions.
Migrate logins, database roles, users and object-level permissions to Amazon RDS for SQL Server using T-SQL
In this post, we explain how to migrate the logins, database roles, users, and object-level permissions from on-prem or Amazon Elastic Compute Cloud (Amazon EC2) for SQL Server to Amazon Relational Database Service (Amazon RDS) for SQL Server using the T-SQL.