SQL to Azure SQL Migration

graph TB
    subgraph OnPrem["On-Premises SQL Servers"]
        SQL1["SQL Server 2016<br/>Production (500GB)"]
        SQL2["SQL Server 2019<br/>ERP Database"]
        SQL3["SQL Server 2014<br/>Legacy App DB"]
    end
    subgraph Assessment["Phase 1 — Assess & Plan"]
        DMA["Data Migration Assistant<br/>Compatibility Report"]
        MIGRATE["Azure Migrate<br/>SQL Discovery"]
        SKU["SKU Recommendation<br/>Right-sizing"]
    end
    subgraph Migration["Phase 2 — Migrate"]
        DMS["Database Migration Service<br/>Online Migration"]
        BACPAC["BACPAC / Backup<br/>Offline Migration"]
    end
    subgraph Targets["Phase 3 — Azure SQL Targets"]
        subgraph PaaS["Fully Managed PaaS"]
            SQLDB["Azure SQL Database<br/>vCore GP 4-core<br/>Serverless available"]
            SQLMI["SQL Managed Instance<br/>GP 4 vCores<br/>Near-100% compatible"]
        end
        subgraph IaaS["IaaS (Full Control)"]
            SQLVM["SQL on Azure VM<br/>D4s_v5 + SQL Std<br/>100% compatible"]
        end
    end
    subgraph Support["Supporting Services"]
        KV["Key Vault<br/>TDE & Secrets"]
        LAW["Log Analytics<br/>SQL Insights"]
        BKUP["Automated Backup<br/>PITR 7-35 days"]
        AAD["Entra ID Auth<br/>Managed Identity"]
    end
    SQL1 -->|"Assess"| DMA
    SQL2 -->|"Assess"| DMA
    SQL3 -->|"Assess"| DMA
    DMA --> SKU
    MIGRATE --> SKU
    SKU -->|"High compat"| DMS
    SKU -->|"Low compat"| BACPAC
    DMS -->|"Online"| SQLMI
    DMS -->|"Online"| SQLDB
    BACPAC -->|"Offline"| SQLVM
    SQLDB --> KV
    SQLMI --> KV
    SQLVM --> KV
    SQLDB --> LAW
    SQLMI --> LAW
    SQLVM --> LAW