Migrating SQL Server to Managed Instance: MI link vs native backup/restore vs Log Replay Service vs transactional replication
This sheet compares Managed Instance link, Native backup and restore, Log Replay Service, Transactional replication.
| Criterion | Managed Instance link | Native backup and restore | Log Replay Service | Transactional replication |
|---|---|---|---|---|
| Downtime | Online, read-only target during migration | Downtime for the backup and restore cycle | Offline, target in non-readable restoring state | Online, continuous for selected tables |
The verdict, the full comparison, 6 rules and 2 traps are part of DP-300 access. Unlock DP-300.