Posts

Azure Arc for SQL server Migration- MI Link

Image
Managed Instance Link Setup- Step By step path The article explains how to prepare an environment for migrating SQL Server databases (enabled via Azure Arc) to Azure SQL Managed Instance using the Managed Instance link . This migration approach uses real-time replication through distributed availability groups , enabling online migration with minimal downtime . Since this option uses a Distributed Availability Group (DAG) hence before we start migration ,we need to set up a few things which we generally do while setting up AlwaysOn Availability group. All the required steps are detailed below and must be completed before starting the migration process.  It focuses on ensuring compatibility, configuring SQL Server correctly, establishing secure connectivity, and preparing both source and target environments before initiating the migration. Prerequisites To successfully use the Managed Instance link migration, the following requirements must be met: Azure requirements Active Azure ...

Steps involved in Azure ARC Enabled SQL server Migration

Image
Once you enable Azure Arc on your SQL Server, the migration process follows the familiar four-step workflow used in most SQL Server migrations: Source Assessment Target Selection Data Migration Monitoring & Cutover The major advantage of using Arc-enabled servers is that all these steps can be performed directly within the Azure portal . There’s no need for separate tools like DMA (Data Migration Assistant) or DMS (Data Migration Service), simplifying the entire migration experience. Let’s walk through each stage in detail: Assess migration readiness – SQL Server enabled by Azure Arc:- When you enable a SQL Server instance with Azure Arc , Azure automatically creates a migration readiness assessment to evaluate how ready that server is for migration to Azure. This is part of planning and modernizing your SQL Server deployment toward Azure cloud services.  What the Migration Assessment Does The built‑in assessment automatically and repeatedly evaluates your SQL Server to h...