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?

[Thomas Deiler · Accepted solution]

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

[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]

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

[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 :-)