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
Пікірлер: 25
Cool
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 ?
this is not on premise to azure, this is azure vm to azure sql database.
@Niravgandhi
Жыл бұрын
kzread.info/dash/bejne/hJ9klsV6od2WZdo.html
I have migration project bro cloud help me on this . I didn’t understand this process bro please help me
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.
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
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
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
hi bro is this on premise to azure, or this is azure vm to azure sql database.
@Niravgandhi
Жыл бұрын
Let me check
@harshini4492
Жыл бұрын
@@Niravgandhi ok
How to migrate the Azure SQL database to Azure Virtual machines.
@Niravgandhi
2 жыл бұрын
It's very easy take backup and restore, if you want zero down time setup always on or database mirroring
@manaswin6569
2 жыл бұрын
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
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
11 ай бұрын
Ok. I will do it
Migration service name means dbdms
@Niravgandhi
Жыл бұрын
Yes