How to Migrate SQL Server from One Tenant to Azure SQL VM with Minimum Downtime
we have a scenario where we have a sql server on 1 tenant that needs to be transitioned to Azure SQL Virtual Machine.
Scenario:
1, Minimum down time
- migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022
- Integration services need to be available on target (eventually we will migrate to data factory0
- If possible transactional replication should be enabled.
Attempted scenarios:
The following has been attempted
DMA- will only support migration to azure db or managed instance
azure Data migration- cannot do migration accross tenants
Data Studio- uses same principals as DMA
cannot use SSMA -targets are non MS SQL
Read more here: Source link
