Migration from ON-Premise SQL Server database to AZURE - Part1

Поділитися
Вставка
  • Опубліковано 31 жов 2024
  • Reach me on +91 9966246368 (whatsapp), if you need any help and support
    IAAS: (.bak)
    Log shipping
    Backup and restore (full+diff (after cutover))
    Attach and Detach
    URL Backup and Restore
    MI: (.bak)
    URL Backup and Restore(full (diff not work))
    DMS (onine)
    Azure sqldb:
    Offline: DMS
    Backpack (schema+data)
    DMA
    Manual (generate script(schema)+ export data)
    Online:
    Transactional replication
    DMS ((offline+ online) (full load + incremental load)
    Data sync (HUB -----Member)

КОМЕНТАРІ • 2

  • @RekhaM-zk6bh
    @RekhaM-zk6bh Місяць тому +1

    Manged instance and IAAS .bak file is working. AZURESQLDB is not supporting.bak file.Why..??

    • @rajasekhar_reddy_bolla
      @rajasekhar_reddy_bolla  Місяць тому +1

      @@RekhaM-zk6bh Azure SQL Database is a fully managed platform-as-a-service (PaaS) offering, meaning Microsoft manages the underlying infrastructure, including backups, high availability, and scalability. Because of this, direct access to the file system (like .bak file restoration) is not available. Instead of restoring .bak files, you need to export data using tools like BACPAC or DACPAC to move databases in and out.