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)
Manged instance and IAAS .bak file is working. AZURESQLDB is not supporting.bak file.Why..??
@@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.