SQL Server to Azure SQL Managed Instance with LRS

When to Use

• Migrate SQL Server databases to Azure SQL Managed Instance with Log Replay Service.
• Run a managed-identity, backup-chain migration that supports low-downtime cutover.

Migrate one or more SQL Server databases to Azure SQL Managed Instance by using Log Replay Service (LRS). Process the complete lifecycle of one database before starting the next database. This skill runs only from Windows and follows the Microsoft Learn managed-identity procedure in the order defined here.

Use the SQL managed instance identity for LRS read/list access to Azure Blob Storage. Take every source backup to an approved local folder, verify it locally, and then copy the completed file to the database's Azure Blob folder with AzCopy. The source does not use a storage credential, storage key, or SAS token. LRS reads the uploaded files by using only the SQL managed instance identity.