Hi team,
We just did an upgrade from 2019.x to 2020.2 and it worked beautifully. That’s some seriously nice work you’ve done there. One small thing, based on the minimum requirements listed here: Raising the minimum requirements for hosting and using Octopus Server - Octopus Deploy i was surprised to see that the upgrade-scripts did not set database compatibility level to 140.
Since you require SQL2017, it might be worth considering. I’ve done this manually, and so far it does not seem to introduce any issues.
USE [master]
GO
ALTER DATABASE [Octopus] SET COMPATIBILITY_LEVEL = 140