Migrate logins, database roles, users, and object-level permissions from Azure SQL Database to Amazon RDS for SQL Server
Database Blog
This article provides a step-by-step guide on how to migrate SQL logins, database roles, users, and object-level permissions from Azure SQL Database to Amazon RDS for SQL Server using T-SQL.
Specifically, the article covers:
- Overview of SQL Server security components like principals, securables, and permissions
- Differences in security administration between Azure SQL Database and Amazon RDS for SQL Server
- Steps to migrate logins from Azure SQL Database to RDS for SQL Server
- Migrating server roles and server permissions
- Migrating users and database roles
- Migrating object-level permissions
- Conclusion and clean-up steps
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 11
2024
2024
Migrate Microsoft Azure SQL Database to Amazon RDS for SQL Server using Smart Bulk Copy
Jul 18
2024
2024
Amazon RDS for SQL Server supports password policies for SQL Server logins
Jun 10
2025
2025
Cross-account migration of Amazon RDS for SQL Server with column-level encryption
Apr 21
2025
2025
Migrate SQL Server user databases from Amazon EC2 to Amazon RDS Custom using Amazon EBS snapshots
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.