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

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ก.พ. 2025

ความคิดเห็น • 29

  • @login4skyworld
    @login4skyworld 2 ปีที่แล้ว +6

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

    • @Niravgandhi
      @Niravgandhi  2 ปีที่แล้ว +1

      th-cam.com/video/Rk04cAqz05w/w-d-xo.html

  • @thavanamsravani5961
    @thavanamsravani5961 2 ปีที่แล้ว +1

    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 ?

  • @etfc944
    @etfc944 2 ปีที่แล้ว +1

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

    • @Niravgandhi
      @Niravgandhi  2 ปีที่แล้ว +1

      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 2 ปีที่แล้ว

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

  • @sunilp8285
    @sunilp8285 2 ปีที่แล้ว +1

    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  2 ปีที่แล้ว

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

  • @P5toraskar1986
    @P5toraskar1986 ปีที่แล้ว +1

    Cool

  • @theinsuranceproblem-j1c
    @theinsuranceproblem-j1c 2 ปีที่แล้ว

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

    • @theinsuranceproblem-j1c
      @theinsuranceproblem-j1c 2 ปีที่แล้ว

      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 2 ปีที่แล้ว +1

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

  • @shivamthacker3126
    @shivamthacker3126 2 หลายเดือนก่อน

    Can we migrate from sql sever to postgresql?

    • @Niravgandhi
      @Niravgandhi  2 หลายเดือนก่อน

      Yes... multiple free tools are available, Google it

  • @harshini4492
    @harshini4492 2 ปีที่แล้ว +1

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

  • @vasanth7507
    @vasanth7507 2 ปีที่แล้ว

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

  • @chamss225
    @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.

  • @MuhammadWaqas-gr4gg
    @MuhammadWaqas-gr4gg 2 ปีที่แล้ว

    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 2 ปีที่แล้ว

      Can u explain to me. Bro

  • @prasangisreenwas9088
    @prasangisreenwas9088 2 ปีที่แล้ว +1

    Migration service name means dbdms

  • @yugandharmayekar8810
    @yugandharmayekar8810 2 หลายเดือนก่อน

    can we migrate from a table from one postgresql server to another?