Migrating SQL Database On-Premise to Azure SQL Database using Azure Database Migration Service (DMS)

In this video, I will provide the complete details of database migration from on-premise to Azure SQL Database using Azure Database Migration Service (DMS).
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nirav_gandhi
Follow me on LinkedIn: / niravgandhisql
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
#azuresql #sql #database

[@P5toraskar1986]

Cool

[@vasanth7507]

I have migration project bro cloud help me on this . I didn’t understand this process bro please help me

[@theinsuranceproblem-j1c]

How did you get your desktop ip on azure portal. Devlocal . Is devlocal on azure iaas

[@theinsuranceproblem-j1c]

If devlocal is azure vm then let me know how I will connect azure dms to my local machine on my desktop

[@thavanamsravani5961]

what is recommended use case for Azure SQL (a)-Migrate all instances of Microsoft SQL server to Azure SQL to improve security and reduce Cost. (B)Migrate your on-permises SQL server instances directly to azure and get all benifits of migrated instances. Which is correct option ?

[@sunilp8285]

In our case we have 800 dbs on Sql server on Azure VM If we use DMA when we select the target sql server Ny questions are how many az sql dbsper azure sql server are supported And do we beed to manyally create az sql dbs on target as well before migrating Data and Schema ?

[@Niravgandhi]

You can use Powershell script or use ARM template or use terraform or az cli to create SQL dbs before migration.

[@MuhammadWaqas-gr4gg]

Hello Brother, First of thanks for these excellent lectures. Amongst all these methods which is best for Online migration with milliseconds downtime??? Secondly in real world to access on-premise SQL server/DB, we will use Private Endpoint or go with the option of Firewall rules also????

[@vasanth7507]

Can u explain to me. Bro

[@MuhammadWaqas-gr4gg]

Sir plz if you could SQL migration through Azure Data Studio method video.....its in gr8 demand now days plz

[@Niravgandhi]

Sure I will try

[@login4skyworld]

this is not on premise to azure, this is azure vm to azure sql database.

[@Niravgandhi]

kzbin.info/www/bejne/iJyTZZZ3pt9ja9k

[@etfc944]

How to migrate the Azure SQL database to Azure Virtual machines.

[@Niravgandhi]

It's very easy take backup and restore, if you want zero down time setup always on or database mirroring

[@manaswin6569]

I hope azure SQL db backups are not compatible with azure Vm and onprem database....please correct me if I'm wrong.??

[@sunilp8285]

Hi any draw backs of using the azure sql Any particular reason you want to switch back to iaas from paas

[@harshini4492]

hi bro is this on premise to azure, or this is azure vm to azure sql database.

[@Niravgandhi]

Let me check

[@harshini4492]

@@Niravgandhi ok

[@chamss225]

no order and sequence of videos. No proper numbering either. unable to find which video is first one and which one is the next one....kindly provide numbering to videos. Author says 1st and 2nd steps already completed in prev video....but i couldnot find that prev video only.

[@Niravgandhi]

Ok. I will do it

[@prasangisreenwas9088]

Migration service name means dbdms

[@Niravgandhi]

Yes