Transfer SQL server Logins to Azure SQL managed Instance

Question

Please provide the procedures to Transfer On premises SQL server logins to Azure SQL Managed Instance.

Answer 1

Hi, @Thyagarajulu B M Thanks for the ask and for using the Microsoft Q&A platform.
Have you tried this document https://learn.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances.

Regards
Geetha

Answer 2

Hi @Thyagarajulu B M ,
You can check this link: https://coderjony.com/blogs/migrate-local-sql-server-database-to-azure-sql-database#:~:text=Follow%20these%20simple%20steps%3A%201%20Open%20SQL%20Server,Login%20%26%20Password%20in%20the%20popup%20window.%20%E6%9B%B4%E5%A4%9A%E9%A1%B9%E7%9B%AE I hope this can be helpful for you.

Answer 3

Hi @Thyagarajulu B M

My approach would be - to export all existing logins from on-premise to a *.sql file, clean that file of unwanted logins, and then execute it on your MI.

https://docs.dbatools.io/Export-DbaLogin

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!