mssql-conf set-edition

sakuraime 2,316 Reputation points
2020-10-24T09:36:35.96+00:00

34704-mssql-config.jpg

just curious what action what actually doing at the back when I choose standard ( if current running is enterprise) .

as I know in windows , downgrading edition should not be allow.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,306 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ronen Ariely 15,081 Reputation points
    2020-10-24T09:49:01.3+00:00

    Good day,

    downgrading edition from Enterprise to Standard is not officially supported directly, but...

    Note: First you need to stop the service

    This is the procedure from the client side (before I had enterprise and I change it to standards) :

    34774-image.png

    as far as I understand this execute behind the scenes a full uninstall and then installation of the lower edition

    Update: Here I found the official documentation. You can notice that changing from Enterprise to Standard is not supported (not in the list) but it is working according to my tests as I show above (with the understanding that this is an uninstall + re-install procedure), but moving from Evaluation Enterprise to Standards is supported (which is why I find no reason to move from Enterprise as well but do it on your own responsibility).

    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15#-edition-upgrade

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,601 Reputation points
    2020-10-27T08:22:38.427+00:00

    Hi @sakuraime ,

    Yes, it is not allowed to downgrade the SQL Server edition as easily as the upgrade edition on windows. The way to downgrade the SQL Server edition is to uninstall and reinstall SQL Server.

    pituach's answer explains the situation on Linux.

    Sorry I don't have a suitable environment for testing.