Share via

How to Migrate SQL Server from One Tenant to Azure SQL VM with Minimum Downtime

Perera, Priyantha 0 Reputation points
2025-05-09T17:05:32.98+00:00

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

SQL Server Database Engine
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 120.4K Reputation points MVP Moderator
    2025-05-09T20:32:55.45+00:00

    BACKUP/RESTORE appears to be the obvious choice. First restore a full backup of the database on the VM with NORECOVERY. Then apply log backups regularly still with /NORECOVERY. At the cutover, but the source database in restricted mode and take a last log backup and then restore it with RECOVERY.

    You will also need a plan for how the clients should start talking to the new server.

    0 comments

Your answer