question

sakuraime avatar image
0 Votes"
sakuraime asked OuryBa-MSFT commented

Database Migration service : Online migration for Azure SQL MI

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-databasesql-server-migration-assistant
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

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



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @sukaraime, Please let us know if that answer above helped. Thanks

0 Votes 0 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered sakuraime commented

@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.



image.png (15.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi . I am doing online migration instead of offline . thanks

0 Votes 0 ·

any update ?

0 Votes 0 ·