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

Question

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

Answer 1

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"

Answer 2

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  

Answer 3

HI Alberto,

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

Mark

Answer 4

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?

Answer 5

Thx Alberto