Automate Migrations from on-prem to Azure Managed Instance via Azure Data Studio using Power Shell

When we Migrate multiple databases from on-premises to Azure Managed Instance using Data studio we have 2 methods.

1) offline
2) Online

In both the modes we have 2 methodologies

(I) Using Azure Blob Containers Means from On-premises we can directly place our Backup files on to Storage container by using Backup to URL. once the files are in place it will the restore them on to MI Automatically.

(II) Using Self Hosted Integration Runtime where the backups from on-premises will needs to be copied on to Network Share. Once the files are there on N/w Share then Azure data studio will copy these files from the share to Storage container and then it restores on to MI.

Now coming to Blob containers when we need to Migrate Multiple databases then if you keep All the backup files under one container then restore will fail. Also when you create Sub folders inside the containers say you are using Ola's Script which means it will create Server Name / Database Name / FULL /finally backup file name then also restore will fail.

So What is the right way to create containers then?????

Answer: We have to create separate container for each database and then we should place our backup files over there.

Imagine you need to migrate 60 databases then how will you automate this??? Don't worry by watching this video you will get to know how to.