Azure Migration Using Data Studio Online and Offline With Integration Run Time and Blob Storage.

This video helps us to Migrate the databases using Azure Data Studio. Azure Data Studio supports Migrating the databases from On-premises to Azure Virtual Machines or Azure Managed Instance (For the Moment). There is no support for Azure SQL but there are high Chances in the mere future as the Microsoft is working on this tool. We have 2 types of Migrations online and offline. Both of them were covered in detailed way. Also Azure Data Studio supports Migrations using Azure Blob Storage and Self Hosted Integration Runtime. I covered both of these techniques with proper Examples.

[@escapetothesky]

Thanks for the very detailed video

[@syedthameemansari4963]

Excellent video especially the folder structure issue is perfectly explained. Can you share the video where self hosted integration run time is configured

[@vamsychiranjeevi9619]

you can reach me on my WhatsApp [phone] for more details

[@thyagaraj1124]

Hello Vamsi Sir. Excellent real-time example of Azure Data Studio migration using DMS. I had referred to the Microsoft document several times, but I still had some questions on the migration steps. Fortunately, I found this video. I have seen the full video, and it has clarified many doubts. Thank you so much for the wonderful content on Azure data migration. If possible, please share your contact details.

[@vamsychiranjeevi9619]

Hi Raj, Glad you liked them. Please feel free to reach me on [phone]

[@balaganesh6992]

Hello Vamsy , Thanks for your video ;; I have a small doubt in we want to migrate from Azure tenant A to Azure tenant B , in this case what is the best way to migrate source database Azure SQL VM running in tenant A to target database azure sql vm ?

[@minkumaxable]

Hello Sir, I saw your complete video, and I found it very helpful and informative, But I have a doubts that if Target and Source database both exists, then can I use Azure Data studio to sync only differential data and I have to perform this activity couple of times, so I'll take the differential backup and only syncing can perform every time. Thanks in advance.

[@vamsychiranjeevi9619]

well, Azure data studio is not a tool designed to sync the databases. It's Main purpose is to drive Migrations. By the way what is your source and the target?

[@minkumaxable]

@@vamsychiranjeevi9619 Thanks for the quick response. My source is SQL server on-prem and my target is SQL server on VM. My on-prem DB has more than 100 TB of data, so to migrate this much, I am planning to move the first full backup using Azure Data box, which will take more than 10 to 15 days, and during that duration, the differential data, I want to sync using Azure DMS. Please advise if this is the right approach or if I should use any other tool or service or a different approach. Thanks in advance.

[@balreddy1185]

What is the Best online approach for migrating azure sql Vm database to azure sql database other than replication

[@shivadevisetti5588]

Could you please do video on “Data migration: Oracle Database On-Prem to Azure Postgresql”

[@GaneTcr]

Hello Sir, on the time 35.28, you have choosen trn file from the blob storage, why? dont we need to choose in the seq FUl, Diff and lastly Trn..if we choose trn then how MI instance know without Full backup how it restore only trn file..

[@vamsychiranjeevi9619]

It knows about your backup files and if it is offline then we need to pass on the last file what ever it is. In my case it was transaction log backup.