I know, this kind of question has already been answered some times but I don't find some current answers and wonder if SQL Server Standard Edition 2016 SP1 has changed something in the matter as it supports all "programmability features" earlier supported by enterprise edition only.
My specific scenario is as follows:
I have got a central backup server which will be running SQL Server 2017 Standard Edition and regulary restores new backups taken from other SQL Server instances. Most instances will be on SQL Server 2017 Standard as well…however there is a Data Warehouse running SQL Server 2014 Enterprise Edition.
- Is it possible to restore backups taken from a SQL Server 2014 Enterprise Edition instance on a SQL Server 2017 Standard Edition instance or could this result in an error regarding to Enterprise Edition features?
- Is there any way to try this out for free? SQL Server evaluation edition is equivalent to Enterprise Edition isn't it or has Microsoft now introduced a way to downgrade developer and evaluation licenses to SQL Server Standard Edition features?
Thank you very much in advance for your assistance
Best Answer
I believe it is possible to restore with same old answer that subject to condition you are not using any "enterprise specific" features. This you can get from
If you are using any such feature you would have to stop using it, take fresh backup and then restore. I know its hard to tell because starting from SQL Server 2016 Sp1 standard provides far more features support. So at the last the answer would be you need to restore and test.
Good news is SQL Server 2017 RTM Evaluation Edition is released so you have the Eval edition for your testing.