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

  • @P5toraskar1986
    @P5toraskar198610 ай бұрын

    Cool

  • @thavanamsravani5961
    @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 ?

  • @login4skyworld
    @login4skyworld Жыл бұрын

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

  • @Niravgandhi

    @Niravgandhi

    Жыл бұрын

    kzread.info/dash/bejne/hJ9klsV6od2WZdo.html

  • @vasanth7507
    @vasanth7507 Жыл бұрын

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

  • @sunilp8285
    @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

    @Niravgandhi

    Жыл бұрын

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

  • @theinsuranceproblem-j1c
    @theinsuranceproblem-j1c Жыл бұрын

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

  • @theinsuranceproblem-j1c

    @theinsuranceproblem-j1c

    Жыл бұрын

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

  • @MuhammadWaqas-gr4gg
    @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

    @vasanth7507

    Жыл бұрын

    Can u explain to me. Bro

  • @MuhammadWaqas-gr4gg
    @MuhammadWaqas-gr4gg Жыл бұрын

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

  • @Niravgandhi

    @Niravgandhi

    Жыл бұрын

    Sure I will try

  • @harshini4492
    @harshini4492 Жыл бұрын

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

  • @Niravgandhi

    @Niravgandhi

    Жыл бұрын

    Let me check

  • @harshini4492

    @harshini4492

    Жыл бұрын

    @@Niravgandhi ok

  • @etfc944
    @etfc9442 жыл бұрын

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

  • @Niravgandhi

    @Niravgandhi

    2 жыл бұрын

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

  • @manaswin6569

    @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

    @sunilp8285

    Жыл бұрын

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

  • @chamss225
    @chamss22511 ай бұрын

    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

    @Niravgandhi

    11 ай бұрын

    Ok. I will do it

  • @prasangisreenwas9088
    @prasangisreenwas9088 Жыл бұрын

    Migration service name means dbdms

  • @Niravgandhi

    @Niravgandhi

    Жыл бұрын

    Yes

Келесі