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?