July 6, 2016 at 8:04 am
Dear All,
I am tryng to upgrade our sql server 2012 sp1 developer Edition to 2012 sp3 Standard edition. We have checked here that this upgrade plan is supported but we receive a strange warning when upgrading.
Everything works fine except that we receive this message warning
"The selected edition downgrade path is not valid. The source Developer edition and the target Standard edition is not supported path."
We erased every trace of columnstore index compression and other enterprise features.
What could cause this issue? We want to be sure that everthing will work correctly before the upgrade.
Thanks for any help you can provide us.
Roberto
July 6, 2016 at 10:04 am
In your article you quote I see this under ²
Changing the edition of a SQL Server 2012 failover cluster is limited. The following scenarios are not supported for SQL Server 2012 failover clusters:
•SQL Server 2012 Enterprise to SQL Server 2012 Developer, Standard, or Enterprise Evaluation.
•SQL Server 2012 Developer to SQL Server 2012 Standard or Enterprise Evaluation.
•SQL Server 2012 Standard to SQL Server 2012 Enterprise Evaluation.
•SQL Server 2012 Enterprise Evaluation to SQL Server 2012 Standard.
Is your server on a cluster?
July 6, 2016 at 10:32 am
Read this article[/url]. Note the warning: "Downgrading to a lower edition cannot be done in place. This tip will describe the steps needed to downgrade."
If you can, install a copy of SQL Server on another machine and test it there. Don't forget to do the test for enterprise features:
SELECT * FROM sys.dm_db_persisted_sku_features
August 1, 2016 at 2:12 am
Hi,
luckily we don't have a cluster. I removed all Enterprise features and then we will try updating using simple product key change.
Did you know if there is a way to find non Database Enterprise features, for example for RS or AS , IS ?
Thanks
Roberto
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply