This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 83%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Can I upgrade from SQL Server 2016 (SP2) 13.0.5026.0 (X64) Developer Edition TO SQL Server Server 2016 Standard Edition?
If yes, can you please provide me the link to the steps or any document.
Thank You
Such an Edition Upgrade is supported, as long as you haven't used any Enterprise features, see SQL Server 2016 (13.x) Edition Upgrade.
You can check used features with
select *
from sys.dm_db_persisted_sku_features
Thank you for the reply.
The above query does not return any row . So, I can conclude that this DB is not using any enterprise features.
Can you please provide me with a link / doc for upgradation. (The data needs to be safe)
Run the SQL Server installer => Maintenance => Edition Upgrade and follow the installation wizard.
See also Upgrade to a Different Edition of SQL Server (Setup)
Can I upgrade from SQL Server 2016 (SP2) 13.0.5026.0 (X64) Developer Edition TO SQL Server Server 2016 Standard Edition?
As per the supported-version-and-edition-upgrades. it is not possible which seems like incorrect thing. As pointed by @abhishek ghosh as per supported-version-and-edition-upgrades going from DEV to standard is supported. One of the odc is incorrect and it is the former one. The downgrade is supported. I searched for similar question and found upgrade-edition-of-sql-server-2016-sp1-from-developer-to-standard this SQLServerCentral QA thread. The OP has similar situation and what he said is below
Just wanted to report back - although I get a SQL Server 2016 edition downgrade warning (treats it as a downgrade as i am going from Dev which allows all features to Standard which doesn't), if I proceed with the upgrade it all works perfectly with no issues! The warning is just that - you can proceed and there are no issues. In my case I am not using any enterprise features so wouldn't experience any issues with this. It would be interesting to know what would happen if you tried to downgrade the edition (from dev to standard) if you were using a bunch of enterprise only features. Would it even let you downgrade? Would it let you but then give you errors when trying to utilize those ent. only features??
So when you do this downgrade you would get a warning something like below, just accept the warning and move ahead and the downgrade should be done.
PS: Make sure you are not using enterprise features which are NOT supported in SQL Server 2016 standard. Unfortunately sys.dm_db_persisted_sku_features would not work correctly.
Dear Shashank,
Thank you for the reply.
Even I thought the same.
But this documents tells that it is possible!
Please advise.
@bhishekghosh-8821 just updated my answer please check. Yes the upgrade is supported but there is something you need to know and that is mentioned in the updated answer. I will report to MS to get the docs corrected.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi,
>Can I upgrade from SQL Server 2016 (SP2) 13.0.5026.0 (X64) Developer Edition TO SQL Server Server 2016 Standard Edition?
This edition upgrade is supported.
Now that you have queried the DMV sys.dm_db_persisted_sku_features and confirmed that your SQL Server developer Edition instance does not use any specific enterprise -level features, there should be no problems with this upgrade.
.
Before upgrading, please back up SQL Server databases and other objects associated with the previous SQL Server instance.
Please check this article for the upgrade process(Installation Wizard (Setup) > edition upgrade).