Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

moving confluence database

Our current confluence db is on a Windows 2008 with 2012 SQL server SP3.
We need to move it.
We need to build an environment to get this moved too, in preparing for that I have a question around using this process to move our confluence db: (see below)
  • Take a backup/dump of the old database using standard database tools, restore it to the target database, repoint confluence and restart it. Pretty much a like-for-like lift and shift
  • Pro: fast, reliable, minimal reconfiguration
  • Con: needs old and new databases to be 100% compatible
My question: is it ok if we build a Windows 2019 with a 2012 SQL server SP4?
Will this allow us to be careful on the CON addressed above: needs old and new databases to be 100% compatible because the SP's would be different.
Should we install SP4 on the current hardware where the confluence db resides before we make this move?

1 answer

0 votes
Brant Schroeder Community Leader Mar 28, 2022

@Kimberly McCarty Here is some great documentation on migrating the DB

If the new DB is 2012 SP4 I would upgrade the old DB to SP4 prior to doing the migration.  Then if you run into any issues you know that the SP difference is not causing any issues.  It shouldn't but it is better to be safe than sorry.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

159 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you