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