How to migrate Azure SQL to Azure SQL Managed Instance?
Because Azure SQL Database is a fully managed PaaS, it does not expose underlying .bak files or transaction log streams. This rules out built-in online tools like the Managed Instance Link, Database Migration Service (DMS) continuous mode, or Log Replay Service (LRS) since all of them require native SQL transaction logs.
To accomplish an online migration for a database of this size without backup/restore, you would need to use a Logical Change-Data-Capture (CDC) or ETL-driven data sync approach.
For details, refer to oneuptime.com/blog/post/2026-02-16-how-to-migrate-from-azure-sql-database-to-azure-sql-managed-instance/view
If the above response helps answer your question, remember to “Accept Answer” so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin
Read more here: Source link
