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

  1. migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022
  2. Integration services need to be available on target (eventually we will migrate to data factory0
  3. 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