Share via

mssql-conf set-edition

sakuraime 2,321 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.
13,361 questions
0 comments
Accepted answer
  1. Ronen Ariely 15,186 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,616 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.