Azure SQL managed instance deployment

Question

Hi, We are planning to migrate SQL server 2008r2 running on Windows 2008r2 to Azure SQL managed instance.
Is it possible to migrate above SQL server to Azure and split between Azure SQL managed instance and SQL Server on VM (on Azure Cloud)?

Answer 1

You have to use Azure migration tool to assessment the Databases before migration as some contents are not supported in the Databases for example SharePoint Database.
Check this https://azure.microsoft.com/en-us/resources/videos/how-to-migrate-sql-server-2008-or-r2-to-azure-sqldbmi

Please do not forget to "Accept the answer" and Upvote on the post that helps you, this can be beneficial to other community members.
http://www.moamenhany.com

Answer 2

Hi @Sam

Here is a video that explains the steps needed for the migration:
https://azure.microsoft.com/en-us/resources/videos/how-to-migrate-sql-server-2008-or-r2-to-azure-sqldbmi/

Other useful ressources are available here:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/migrate-to-instance-from-sql-server
https://azure.microsoft.com/en-us/migration/sql-server/

--I hope this helps. Please Accept it as an answer and "Up-Vote" the answer or message(s) that helped you so that it can help others in the community looking for help on similar topics

Regards,
Didier3001