Migrate to Azure SQL Database Managed Instance

In this weeks edition of Data Double Click, Tim Radney and I show how to migrate an on-premises SQL Server database to Azure SQL Database Managed Instance. Tim is a Principal Consultant with SQL Skills, and he and I walk through all the steps, processes, and best practices to successfully migrate to M.I.
I spend the first half discussing and walking through the networking aspect of M.I., and Tim shows the actual migration steps in the last half.
Throughout the video, Tim and I call out common errors and mistakes people make, and highlight configuration and provisioning best practices to ensure a successful migration.
For more information on SQL Database Managed Instance, visit docs.microsoft.com/en-us/azur....

[@PavanKumarBolikonda]

Yes, its really great vedio to watch and build your skills in setting up Azure SQL DB MI successfully. Thanks to authors. This vedio helped me in understanding the flow of Azure MI in a crystal clear.

[@akashmaru]

Thanks a lot for the very useful content, much appreciated

[@Psychosix]

Thanks, guys. Worked great.

[@sandeepsawant8052]

Nice video Tim... It is really useful

[@jeriljose9515]

Really great Video :) lot of information shared in Managed instances

[@caingianni4678]

pro tip: watch movies on flixzone. Been using them for watching all kinds of movies these days.

[@dariothomas3392]

@Cain Gianni yup, have been watching on flixzone} for months myself =)

[@BalvinderSingh-uh3my]

New to Azure (your video the 1st) I did a srdf migration back in the day no other way other than a backup restore a really problem massive databases restore time. Also Linux and Oracle databases, thanks.

[@iamrooot5916]

Thanks for this. Also i have a question, how about sql migration with 5tb of data. Is this possible using blob storage? As par i know blob has a limit to 1tb. We tried to backup our onprem sql using blob storage but always fails because the storage has limit to 1tb.

[@saket6]

Excellent demo but little bit missing. Video didn't discuss about compatibility assessment and handling compatibility issues if exist. Could you please let us know what what all are the compatibility issues might occur during on prem to Azure SQL server managed instance.

[@vibhaskashyap8247]

Thanks for the session. can you please clarify following 1. Is there limitation on the amount of data to be migrated from on-prem to Azure SQL Managed Instance 2. How much time it takes to backup and restore 1TB of data ? If there is 2 TB data to be migrated does time to copy increases in linear fashion? 3. How does validation gets handled ?

[@AbdulWahab-jn7sr]

Nice vedio, I have follow all the guidance and created virtual instance. But I am unable to access by host string through SSMS. I don't have idea how to troubleshot it Error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060). Can you please help ?

[@bobbush5339]

Nice

[@soumikdas7709]

It could have been better if things get credited during the show.