We are planning to upgrade our Octopus Server from 2018.8.5 to 2020.3.2. We are planning to build two completely new servers for both Octopus and SQL server(2012=> 2017); then upgrade both.
Here is the step we plan to do:
1: backup database in SQL 2012 and restore the database in SQL 2017.
2: move the Octopus server to new environment and install 2018.8.5 and connect with DB
3: Upgrade the Octopus server to 2020.3.2; the database schema will upgrade during this update
4: Test one week on the new server while the old server still have on-going deployment
==cut-over day (weeks later) ==
5: backup the database in 2012 and restore in 2017 again;
6: Test in the new Octopus Server with new data
But we got a few questions here:
In the above step 3, during the connection with new octopus server, the database might changed the schema. So when we restore with newest data in step 5, it may have outdated schema, will the connection work? do we need to upgrade the octopus server in the cutover day?
I guess the question really is how to upgrade the database without touching the OD software?
During the Octopus upgrading, is Calamari need to be upgrade?