Octopus Upgrade 2019.9.10->2020.4.6

We currently have a 2019.9.10 server with LOTS of projects, and 2020.4.6 server we’re moving to with a blank database.

We would like to make a backup of the 2019 database, and restore it to a new database, and then attach the 2020.4.6 server to that new, 2019 database.

When we do that will the schema upgrade automatically from the 2019.9.10-> 2020.4.6 ?

Thanks!

Cam

Hey Cam,

Thanks for reaching out.

Unfortunately, the SQL schema upgrades happen when you update Octopus with the installer. When moving databases the versions have to be the same.

I think you would need to make a backup of your 2019 DB, then upgrade your 2019.9.10 instance to 2020.4.6, then finally attach that database to your 2020.4.6 instance.

Were you intending to keep your 2019.9.10 server on that version as a backup, or is it okay to upgrade that to get the new schema?

Optionally, you could install 2019.9.10 on the new server(instead of 2020.4.6 right off the bat), then attach the database, then do the upgrade to 2020.4.6, leaving your 2019 backup and 2019.9.10 server intact.

Please let me know what you think.

Thanks,
Jeremy

Thanks for the response Jeremy.

Yes that’s what we’re planning now .
Down the old 2019 octo server
Backup old 2019 octo database
Restore 2019 octo database to new DB
Bring up the 2019 octo server on new server
Point new 2019 octo server to new DB with 2019 data
Do in-place upgrade of octo 2019 to 2020
Pray and test.
If it doesn’t work out, down the new server and bring back up the old one

Sound like a decent plan?

Thanks!

Cam

Hey Cam,

That plan looks solid to me. Make sure you take note of your master key because you’ll need it.

Here’s some documentation on moving your server. While that’s not exactly what you’re doing, a lot of it should still apply. https://octopus.com/docs/administration/managing-infrastructure/moving-your-octopus

Please let me know if you have any other questions or if you think you’re good to go.

Thanks,
Jeremy

That’s perfect, we’re good! Thanks!
Cam

1 Like

Hi Cam,

You’re very welcome! Thanks for letting me know.

I hope you have a great weekend.

Thanks,
Jeremy