I need to upgrade and migrate SQL Server, SSRS, SSIS to the newest OS version and SQL Server version.
Server OS is currently 2008 R2 with SQL Server 2008 R2 Ent. installed.
My original plan was to do in place upgrades and then migrate to new server OS. It sounds like SQL Server 2017 is not supported on 2008 R2, so I'm not sure whether or not this is an option.
What is the best migration/upgrade path for server OS upgrade and SQL Server version upgrade?
Windows Server 2008 R2 and SQL Server 2008 R2 Ent -> Windows Server 2019 and SQL Server 2017 Ent.