On Premise SQL Server to Azure | Azure DMS Migration | SQL Server Migration to Azure | Azure SQL

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

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

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

    Do refer to my below playlists,
    Microsoft Azure
    th-cam.com/play/PLmSlOWkfkuglJzo6VOX_vPJHAHBkullPT.html
    Hyper-V Playlist
    th-cam.com/play/PLmSlOWkfkugmYvibN0s2SQ5XAk7Z9jD21.html
    VMware vSphere Playlist
    th-cam.com/play/PLmSlOWkfkugnrD_VdpiaXRWppa0U4u0gt.html

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

    Hello brother, I am doing migrations via Azure Migrate, ADS and ASR....Still companies are using ASR even now....One thing which really pinch me is that, If we do a failover from On-premise to Azure...a new VM is created and eventually new IP Address is assigned to that VM....but how customers assess that new VM as IP address has been changed due to failover and how DNS will point to new IP address...this is what i am facing now a days...if you could make me understand migrations/failover perspective plz, i would be grtful.

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

      I haven't worked on ASR yet. But after failover, you can change the IP in the application.

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

    What a wonderful lecture on SQL migration...a complete package even for a tenth grader can learn SQL level migration from this video...hatts of to your hard work and dedication....
    lot of respect for you man.....
    I have a question as why we have configured Private endpoint??? and then deleted in end....could nt get that as what was the use???
    Second, in subscription under left panel u selected some Resource providers for Migration....i also couldnt get that also..plz if u could respond to this query as well.
    thanks for this wonderful video....

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

      1--For connecting the SQL to any service we have to create an endpoint as SQL cant be connected over the public network. Database Migration service is responsible for migration so we have to create a private endpoint on the SQL side which gives connectivity to DMS with SQL.
      2--Database Migration Service(DMS) is not automatically registered with Free Subscription, we have to register it to our subscription using a resource provider.

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

      @@VirtualTechBox How could i forget that we need endpoint to access our storages and DBs privately.......cut my marks dear....

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

      @@MuhammadWaqas-gr4gg 👍

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

      @@VirtualTechBox ok dear...but what if we r using a paid subscription...in that case still we will need Resource provider or we will not???
      Secondly u said, we used Private endpoint to access SQL DB...then in the end why we deleted that endpoint??? Was it used only for migration and thats it...because after migration we dnt want to access our On premise DB anymore??? is this the reason for endpoint deletion???

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

      @@MuhammadWaqas-gr4gg That private endpoint was only for connectivity between SQL server and DMS, after migration it has no use so we deleted it.

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

    Awesome information can you please kindly make videos on how to migrate On Premises Windows Server to Azure with detailed steps

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

      Already there. Refer to below videos,
      th-cam.com/video/xS44gE0rtCs/w-d-xo.html
      th-cam.com/video/6ox0_kfWEGc/w-d-xo.html

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

      @@VirtualTechBox Thanks this are for Hyper V and VMWARE to Azure Migration respectively, waiting for the one from Onpremises Windows Server 2008/2012/2016/2019 to Azure Cloud Migration

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

      @@supriyochatterjee4095 You mean on-prem physical windows server to Azure?

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

      @@VirtualTechBox i think he is asking the same....

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

      @@MuhammadWaqas-gr4gg Ok.

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

    Ashfaque brother, i have an imp question...In companies where there is huge amount of data to be migrated/transferred to Azure from On-premise....they use a Azure Databox service where physically hard disks are migrated...so how do u apply migration steps in that case???? or there would be a different migration scenario???

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

      Databox is an offline method and downtime is more in that case. I will try to make a video on databox also.

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

    Super Video !!!

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

    Ashfaque bhai, is this method under Azure Migrate supports only migration to Azure Sql or Azure Managed Instance as well?? I mean u r using DMS....so a Target DB can only be a Azure SQL or we can also migrate to Azure Managed Instance as well...???

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

      Never tried to migrate Managed instance using DMS.

  • @vijayBomma-y1c
    @vijayBomma-y1c ปีที่แล้ว

    what are the issues we will face in feature parity or compatability issues,if we face how to resolve them,please explain them

    • @VirtualTechBox
      @VirtualTechBox  ปีที่แล้ว

      That depends on error you get during migration.

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

    Ashfaque bhai, What if we have 5 SQL on-premises Servers...in that case we have to install DMA on all 5 SQL Servers??? And i think there will be 5 projects with 5 separate migrations or whatelse??and how VPN will be configured for that setup??Please guide....would be grtful.....

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

      The migration project can be single but we will have to install DMA on all 5 SQL servers. If all 5 are in the same network then our vpn will work for all.

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

      Thanks a lot Man...u r simply outstanding...

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

      @@MuhammadWaqas-gr4gg 👍

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

      @@VirtualTechBox So can we migrate DBs from different servers after having accessed by DMA separately to a single Azure SQL Managed Instance ???

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

      @@MuhammadWaqas-gr4gg Yes.

  • @kumarans6711
    @kumarans6711 ปีที่แล้ว

    Is it possible to migrate onprem cluster vms to azure and onprem always on sql cluster vm to azure through Azure migrate ? If yes pls explain it

    • @VirtualTechBox
      @VirtualTechBox  ปีที่แล้ว

      Yes. If those VMs are on Hyper-V or VMware, then it is possible. I have a video on VM migration on my channel.