Log shipping from SQL Server 2014 Enterprise db to SQL Server 2017 Standard with partitioning I wish to implement log shipping from my current primary which is a SQL Server 2014 Enterprise database to a SQL Server 2017 Standard edition database. I also wish to implement table partitioning on my primary (2014 Enterprise) database. Table partitioning only became available at Standard edition level from SQL Server 2016 Standard SP1 onward. 

I believe this will work I need to test it first. My problem is that SQL Server Evaluation edition seems to only correspond to Enterprise/Developer edition or at least that is my understanding. I do not have access to 2017 Standard edition without purchasing but do not want to purchase it without knowing if my proposed log shipping implementation would work for sure. 

Has anyone else implemented similar, or does anyone know how to restrict an evaluation edition so that it corresponds to Standard?
I believe this will work I need to test it first. My problem is that SQL Server Evaluation edition seems to only correspond to Enterprise/Developer edition or at least that is my understanding. I do not have access to 2017 Standard edition without purchasing but do not want to purchase it without knowing if my proposed log shipping implementation would work for sure. 


According to the Docs, Express Edition can also handle table partitioning in 2016 SP1+. Thus you could setup an extremely small database, create a new partitioned table, and log ship it from 2014 Enterprise Edition to 2017 Express Edition and see if it works. Express edition is free and can be easily downloaded and installed.

If it works, then it'll work in Standard. If it doesn't, then it won't work in standard and it has some but not all feature parity across editions in 2016 SP1+ with partitioning being one of those that is available across all editions.