Excellent demo. I think online migration we can access the database while migration is happening but at the time of cut over only you can not access that is called minimal down time. Online migration it will restore the log files until you select cut over.
Yes. That's correct. We need to get the downtime to switch over the DB from on-premise to azure SQL. I guess we need to create DNS record to point to azure DB accordingly.
Dear Sir, Your explanation on online and offline migration explanation is not clear. Offline migration means before migration starts you need to completely shutdown the source db down , take back and restore it in the target environment. if the migration takes 10 hours, all the 10 hours source database will not be available. In online migration without shuting down the source database L0 backup will be taken and target environment database will be cloned. During the cutover phase we will shutdown the source database and take L1 backup and apply in the target environment. In online migration the availability of source will be at maximum. There will be less business impact
I found the best and excellent explanation regarding SQL migration with Azure
Really awesome explanation and patience you maintained.
Good one and Great Explanation with practical Session
Appreciate your knowledge and excellent explanation step by step....Thank you very much!!!!
Nice brother Well tried appreciate your efforts. humble in teaching good go . All the best,
this guy is a pure legend!
Excellent demo. I think online migration we can access the database while migration is happening but at the time of cut over only you can not access that is called minimal down time. Online migration it will restore the log files until you select cut over.
Yes. That's correct. We need to get the downtime to switch over the DB from on-premise to azure SQL. I guess we need to create DNS record to point to azure DB accordingly.
Thanks Bro.. Good Job and it is clean & nice explantation.
Thanks Bro , very helpfull video .. was able to complete all 3 labs ( DAC,Bacpac , DMS)
Thank you so much for the video! It cleared so many doubts..
Learned a lot in this video. Thank you very much !!!
Well explained ..thanks sir
Very good Explanation 👍
Thanks you. I learn so many things.
Excellent explanation.
Thanks .Very good explanation
Thanks very well explained!! For what volume of Data we should go With DMA?? is it below 50GB or any specific Volume?
Appreciate ur efforts bro ....you could have added a point deletion after migration too then it would become realtime based scenario
Excellent!!!
It's a very useful and details presenation. Can you please share the power point link to download the presentation would be helpful to track changes
Can I get this done using ADF as well ? Azure data migration. Just to move a few tables to azure sql dB
informative
Can't we do backup and restore insted of bacpac
Good job!
you could have added a point deletion after migration too
If we have all this processes then why we are using AZURE DATA FACTORY?
Data Factory main purpose is to do Cloudbased ETL Operations ...u have copy option too as an added point but that doesnt mean actual requirement ..
Dear Sir, Your explanation on online and offline migration explanation is not clear. Offline migration means before migration starts you need to completely shutdown the source db down , take back and restore it in the target environment. if the migration takes 10 hours, all the 10 hours source database will not be available. In online migration without shuting down the source database L0 backup will be taken and target environment database will be cloned. During the cutover phase we will shutdown the source database and take L1 backup and apply in the target environment. In online migration the availability of source will be at maximum. There will be less business impact