• doodlingdba - Tuesday, May 22, 2018 6:29 AM

    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??

    Thanks all!

    No.  You would have to remove the Enterprise features from any database before doing the downgrade.  Ran into this in Afghanistan because one of our production servers actually had Enterprise Edition installed and someone (not me) had decided to experiment with some Enterprise features.  This was also on SQL Server 2005 which didn't have the nice DMVs that helped identify the features in use.  Took a bit of digging to identify all the features they used.