Is there any way to convert standard sql from enterprise sql in Azure platform?

Faisal Ali 1 Reputation point
2022-11-03T05:21:57.577+00:00

i have accidentally deploy azure enterprise sql instead of standard sql, is there any way to convert standard sql from enterprise sql in Azure platform.

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. rafalzak 3,216 Reputation points
    2022-11-03T07:02:37.937+00:00

    Hi @Faisal Ali ,

    It's not supported. You need to completely reinstall it or recreate it with proper version.
    Please find another case for reference:
    https://learn.microsoft.com/en-us/answers/questions/49461/downgrade-sql-server-2016-enterprise-to-sandard-ed.html

    Please upvote or accept as answer if it helped.


  2. Bjoern Peters 8,856 Reputation points
    2022-11-03T15:11:34.443+00:00

    Hi @Faisal Ali

    If that given VM is deployed as an Azure SQL VM from the marketplace, and you are using the IaaS SQL Server extension, then you should be able to change the Edition "on the fly" without the need of a complete re-deploy!

    Windows SQL Server IaaS Agent extension
    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management?view=azuresql&tabs=azure-powershell#feature-benefits

    In-place change of SQL Server edition on Azure VM
    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition?view=azuresql

    0 comments No comments