Database Migration service : Online migration for Azure SQL MI

asked 2021-04-21T13:08:02.647+00:00
sakuraime 2,271 Reputation points

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 .

Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
365 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2021-04-21T18:55:42.467+00:00
    Oury Ba-MSFT 9,561 Reputation points Microsoft Employee

    @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")
    90054-image.png

    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.


  2. answered 2021-04-27T16:51:48.577+00:00
    Oury Ba-MSFT 9,561 Reputation points Microsoft Employee

    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