SQL Server migration to Azure using Azure Data Studio to assess, recommend Sku and migrate.

[@mquinnusa]

This is great. Thank you so much. 😃

[@SQLTalk]

Thank you @mquinnusa!

[@pdsqsql1493]

Very nice in detailed explained presentation!!! If we once migrate then for actual cutover we can overwrite it?

[@MuhammadWaqas-gr4gg]

why didnt you install Ms Integration Runtime here?

[@SQLTalk]

I didn't install the Integration Runtime on this one since my SQL Server backup files were located in an Azure storage account. See minute 11:25. Thank you for your comment.

[@ibexy]

The backup to url sopped working. Keeps returning error 400.

[@MuhammadWaqas-gr4gg]

Hello, nice video...So we will also need VPN connection for this setup???? Secondly Data Studio will be installed on every on-premise SQL Server???? What if the SQL servers/DBs are in VMware setup????Same method will be applied???? PLz reply.

[@SQLTalk]

If the destination DB doesn't have a public IP you will at least need a Point to site VPN. Azure Data Studio does not have to be installed on any SQL Server. You can run it from your client or maybe a central server in your destination environment. Yes, you can use ADS to point to SQL on VMWare. For migrating many SQL Servers on VMware you may want to use Azure Migrate.

[@MuhammadWaqas-gr4gg]

@@SQLTalk Still not clear suppose if i have to migrate 50 servers with 100 DBs then what would be the scenario????How many Azure SQL MI will be required??? 1 or 50??? or depends on Service tier??? am confused....

[@SQLTalk]

@@MuhammadWaqas-gr4gg SQL MI will currently support 100 databases per MI.

[@MuhammadWaqas-gr4gg]

@@SQLTalk Wow Thanks brother so it means we can only access a single server having multiple DBs with ADS in a single migration event???? But for every SQL SERVER we need seperate ADS migration operation???

[@MuhammadWaqas-gr4gg]

@@SQLTalk But also we cannot access/connect multiple SQL servers with ADS in one migration go??? one more question, can we migrate DBs from multiple SQL servers to Azure MI in ADS???

[@MuhammadWaqas-gr4gg]

One question strikes me, What if we use DMA for Assessment and DMS for Migration/cutover......So what would be better migration.........Data Studio with DMS or DMA with DMS?????Any points...

[@SQLTalk]

DMS should be used if your destination is Azure SQL DB. ADS supports Azure SQL MI and SQL VM's as a target and is the preferred method. I assume that Azure SQL DB as a target option will be added to ADS. The ADS migration you set up will show up in DMS (think of it as DMS v2) and you can monitor all your ADS migrations centrally in Azure DMS. DMA UI and command line can still be used but it doesn't have the SKU recommendation feature.

[@MuhammadWaqas-gr4gg]

@@SQLTalk Brother i have checked in Azure Migrate as well as in DMS, Target DB can also be Azure MI apart from Azure SQL...

[@SQLTalk]

@@MuhammadWaqas-gr4gg correct Azure Migrate supports all three target types, Azure SQL DB, SQL MI and SQL on a VM. However, if your target is not going to be Azure SQL DB then you may prefer the experience of Azure Data Studio (ADS) with SQL Migration Extension. You can do everything from ADS, assess the source for compatibility with Azure SQL, get a sku recommendation for Azure SQL and do the on or offline migration.

[@MuhammadWaqas-gr4gg]

@@SQLTalk Agreed brother....Its better to go for ADS then...thanks.