It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

What is the best way to migrate Confluence from Oracle to MySql (or Postgres)?

We have an OLD (3.49)  on-prem internal Confluence install that uses Oracle for the database.  We are considering migrating the data from it into a new Confluence instance.  The new instance will probably run on EC2 in AWS.  I'd like to use either MySQL or Postrgres with the new instance.   What is the best way to move the legacy data?  

The existing db is roughly 25 GB.  I have seen the statement:

"Large data sets will require third party database migration tools."

at  https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Does a 20-30GB database count as a "Large Data Set"?

What 3rd party tools exist and which have the best track record.

We do have a lot of legacy plugins, but right now, we would probably accept some "breakage" to get things up to a modern state.  Maybe we would be better served to export/import individual spaces...

2 answers

1 accepted

0 votes
Answer accepted

Hello Brad,

Thank you for including details into what you’re wanting to do with Confluence. Your database size is not a massive amount of data. With this said, you should be able to perform the export/backup and restore that is referenced within the article you linked. There are a few things to consider when moving forward.

  1. Ensure you're restoring into the current version of Confluence you’re running to avoid disruption or issues. You’ll need to install another instance of 3.x and restore your backup into that.
  2. Alternatively, you can upgrade to 6.x on your current instance (Upgrade from 3.latest > 4.latest > 5.latest > then to 6.x). Once upgraded you can then perform the backup and restore process into a new instance of 6.x. This will also make you eligible for support outside of Community.
  3. Another option would be to upgrade Confluence to a version which allows you to export to a cloud product and avoid the database migration altogether. More about this may be found at Plan your Confluence Server to Cloud migration.

I hope this information proves helpful with migrating your data to a new instance and a new database.
Regards,
Stephen Sifers

Thank you.  I was hoping that we were small enough to use the standard tools.  It sounds like that is the case.  I appreciate your feedback.

 

Thanks for your time,

Brad Guenther

Like Stephen Sifers likes this
0 votes
Emily_Chan Atlassian Team Jan 13, 2020

Hi @brad and Community!

We've just built the beta of a solution to help ease migrations from Server/Data-Center-on-prem to Data-Center-on-AWS-Quickstarts.

Would you be interested to join our beta program and try out this solution? If you're interested, or would like to find out more, please email me at echan@atlassian.com. 

Hi Emily,

I am trying to migrate from Oracle to MySQL (atlassian-confluence-6.15.4, large DB). Server/Data-Center-on-prem->Server/Data-Center-on-prem. Just wondering, maybe your toolset could do the job?

Thanks,

Vadym Khanko

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

283 views 9 7
Join discussion

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