Database Migration service : Online migration for Azure SQL MI

Question

Database Migration service : Online migration for Azure SQL MI didn't help to migrate the SQL Logins.. Is it a bug ?

while choosing offline migration will allow you to choose the login to migrate .

Answer 1

@sakuraime Welcome to Microsoft Q&A and Thank you for posting your question.
If you are trying to migrate from SQL server to SQL Managed Instance, please go through Migrate SQL Server to SQL Managed Instance offline with PowerShell & Azure Database Migration Service and verify you did not miss any steps. There are a few additional requirements you need to address:

Select logins. Create a list of logins to be migrated as shown in the following example:

PowerShell

Copy
$selectedLogins = @("user1", "user2")

Please do let us know if you have further query. Please mark posts as answer if it answers your query. This would be helpful for others community members facing the same kind of problem.

Answer 2

Hello @sakuraime Login migration workflow is currently available only in the offline migrations to Managed Instance.

The way that you can migrate logins is to complete the online migration and then run the offline workflow, you don’t need to select any database, just select the logins to move. The login workflow would then move the logins (converting them to AAD logins as required) and then map the users across databases that the account has privilege over. Hope that answer your question.
Please mark as answer if that helps because it will be useful for other community members who are facing the same issue. Thanks