nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migrating Confluence 6.2 from mySQL 5.6 to Oracle 12c

Jim Dryden

Hi everyone,

I support Confluence 6.2 (on-premise, Windows 2016 R2). Leadership wants a more robust database with better in-house support, so I'm evaluating a database move from locally hosted mySQL 5.6 to externally hosted Oracle 12c. Our database is small to medium sized (less than 2gb, but we have over 5gb in attachments stored on the file system). Does anyone have experience migrating from mySQL to Oracle? Any advice on tools or data migration paths?

Accepted answers

Thomas Deiler_db00h3

Dear @Jim Dryden,

thats simple. Export Jira to XML (Backup), stop Jira, change your dbconfig.xml file, add the right JAR for Oracle, restart Jira, restore the dump. Done.

Of cause for safety make a backup of the whole JIRA_HOME.

So long

Thomas

All comments

Thomas Deiler_db00h3

Dear @Jim Dryden,

thats simple. Export Jira to XML (Backup), stop Jira, change your dbconfig.xml file, add the right JAR for Oracle, restart Jira, restore the dump. Done.

Of cause for safety make a backup of the whole JIRA_HOME.

So long

Thomas

Vickey Palzor Lepcha

I've heard a lot about data integrity issue while using data of one database to another - do check that as well and let us know :-)

Jim Dryden

Hi Thomas,

Thank you for your prompt response. Unfortunately, I am speaking of Confluence, not Jira. Do you have any experience with migrating a Confluence data export? I hope i've not posted to the wrong forum.

Thanks,

Jim

Vickey Palzor Lepcha

JIRA and Confluence both run under the same basic principle and concept - you can do the same with Confluence too.

Thomas Deiler_db00h3

Dear @Jim Dryden,

Vickey is right - same for Confluence. And sorry for the upper typo - I am so often switching between both apps while answering questions ...

So long

Thomas

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

oracle

mysql