doodlingdba - Thursday, March 8, 2018 9:01 AM

Hi all

Having a strange issue. We have a production server which incorrectly got installed with Developer edition. The upgrade path is supported according to this article:

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades

I go through the Edition Upgrade by launching the setup.exe and going to the Maintenance tab in SQL Server Installation Center.  I choose the instance to upgrade and when I get to the Feature Rules tab, all of my rules pass except the SQL Server 2016 edition downgrade which gives me a Warning:

Very strange as i'm not doing a downgrade? I ran SELECT * FROM sys.dm_db_persisted_sku_features and the only enterprise feature in use is Compression. This feature is supported in Standard edition in SP1 so this shouldn't be a problem but just in case, I removed compression (was only used on one table, one of Ola Hallengren's). However i am still getting the same warning.... don't know why but i don't feel confident proceeding with the upgrade (it is after all just a Warning so it should let me proceed but can't risk it falling over half way through).

Any ideas???

Thanks!