Migrate SQL to Azure Managed Instance. What happens to edition?

asked 2022-12-22T17:48:23.5+00:00
Mark Gordon 641 Reputation points

Fellow DBA's.

If you are migrating an on-premise SQL 2016 Standard Edition to Azure Managed Instance, does it stay the same edition or does it automatically jump to Enterprise?
Thanks
MG

Azure SQL Database
No comments
1 vote

Accepted answer
  1. answered 2022-12-23T15:10:14.75+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    The edition is no longer de same. Once you migrate to Azure SQL Managed Instance the edition is now "'Azure SQL Managed Instance'". The edition is no longer "Standard" or "Enterprise"

    No comments

4 additional answers

Sort by: Most helpful
  1. answered 2022-12-22T18:36:25.297+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    Once you migrate the instance to Azure SQL Managed Instance the Edition name is "Azure SQL Managed Instance" as mentioned here. The Id of the edition is 8 as shown on the query below:

    SELECT CASE ServerProperty('EngineEdition')  
    WHEN 1 THEN 'Personal'  
    WHEN 2 THEN 'Standard'  
    WHEN 3 THEN 'Enterprise'  
    WHEN 4 THEN 'Express'  
    WHEN 5 THEN 'SQL Database'  
    WHEN 6 THEN 'Azure Synapse Analytics'  
    WHEN 8 THEN 'Azure SQL Managed Instance'  
    WHEN 9 THEN 'Azure SQL Edge'  
    WHEN 11 THEN 'Azure Synapse serverless SQL pool'  
    ELSE 'Unknown'  
    END  
    
    No comments

  2. answered 2022-12-23T14:28:40.673+00:00
    Mark Gordon 641 Reputation points

    HI Alberto,

    What I am asking is if the edition stays the same (i.e Standard) ?

    Mark

    No comments

  3. answered 2022-12-23T16:17:59.747+00:00
    Mark Gordon 641 Reputation points

    Ok. So, then how is it handling the differernce between you original Standard vs Enterprise when enabling features? Are you saying that my original Standard will become fully Enterprise Featured?


  4. answered 2022-12-24T16:08:40.717+00:00
    Mark Gordon 641 Reputation points

    Thx Alberto