Confluence migration/upgrade

Question

We're moving Confluence from Windows Server 2012 to Server 2019.  The old server is being retired but is still the "Production" server until the upgrade is complete.  We also need to upgrade from Confluence 6.15 to 7.12.  I made a copy of the original SQL dB and also the install and home directories and put hem on the new server.  I updated the configurations to point to the new copy of the SQL dB.  We ran the upgrade and that completed.  Once we're ready to make the final cut-over, how do we do that?  Need some way to get a final copy/backup of the original Confluence content & dB and get it into the new instance so we can make the DNS switch and cut-over.  How do we do that?

wdonovan · Answer

Sandbox will become production.  The old production environment will be retired after the migration is complete.  Hopefully we don't have to wipe out sandbox and repeat the entire process.  It was far from easy.

Jamie Rogers_bnmiyu · Answer

Is your sandbox going to become your new production database OR are you wanting to re-test your upgrade plan? I am not sure about merging changes from prod into your upgraded staging instance without blowing away the lot and repeating the process.

Normally when we do our upgrades we upgrade the test/staging instance(s) including its database and then repeat in production. Snapshots of the VMs and database are taken prior so we have a rollback point should something go wrong.

wdonovan · Answer

Our database was also on a separate server but would couldn't have 2 instances of Confluence (sandbox & production) pointing to the same database.  We had to make a separate (copy) database for our sandbox instance.  Now this new sandbox instance has been upgraded to version 7.12 so we need to get any last changes made in production over to the sandbox before we do the cutover.  Is it just a back from production and restore into sandbox to move the final changes over?