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

Go to article

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.

Apr 11
2024

Migrate Microsoft Azure SQL Database to Amazon RDS for SQL Server using Smart Bulk Copy

May 21
2024

Migrate a multi-TB SQL Server database to Amazon RDS Custom for SQL Server using Amazon FSx for Windows File Server

Jul 3
2024

How to clone master user permissions in Amazon RDS for SQL Server

Jul 18
2024

Amazon RDS for SQL Server supports password policies for SQL Server logins

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.

Migrate logins, database roles, users, and object-level permissions from Azure SQL Database to Amazon RDS for SQL Server

Related articles