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; } } }

Can I migrate Jira from Postgres to Oracle using the XML backup?

Sean Johnson_8fqcu7

I have been tasked with upgrading Jira 5.0 to current AND because we are an Oracle shop they would like me to move our jira db off of Postgres to Oracle. (I have been the Jira admin, but I'm not a dba or dev guy).

1) Can this db migration be accomplished thru the XML backup?

2) Are there predefined versions I must touch in the upgrade path? Surely I don't need to stop at each version, right?

Information on these subjects has been difficult to sort out for me.

Thank you,

Sean

Accepted answers

All comments

Nic Brough -Adaptavist-

1) Yes

2) No

Do the database migration and the upgrade as different projects (even if the go-live plan is to do them together). Use Postgres until you get to a version of Jira that is best for the migration to Oracle and do the migration on the same versions rather than try to include it as part of an upgrade.

Starting at Jira 5.0, the recommended upgrade path is 6.0 -> 6.4 -> 7.0 -> 7.target. You might be ok to jump from 5.0 to 6.4, but do not try to go straight to 7.0, and do not try to skip the 7.0 step.

Sean Johnson_8fqcu7

Thank you Nic.

Sean Johnson_8fqcu7

Dumb follow up question. I'm also moving to a new server. This might violate one of the principles you shared, but I'm wondering if I can I take this approach:

-Create XML backup

-Build new server and install clean Jira 5.0 or 6.0 w/Oracle connection and use XML to restore jira projects (ie. bypass postgres entirely)

- then proceed to follow the upgrade path.

Sean Johnson_8fqcu7

You said, "Use Postgres until you get to a version of Jira that is best for the migration to Oracle "

Are you suggesting this because of the Oracle support offered at each Jira version?

eg. Java 1.8 isnt supported until jira 6.4... And I'm assuming I need the project structures in the db to upgrade with the software.

So in that case, can I create and migrate Jira to currect using the H4 eval db, and then connect to Oracle when I'm at an appropriate version. (we are limited on postgres dba's here so trying to avoid using that if possible.

thanks again.

Nic Brough -Adaptavist-

Not dumb at all.

Your proposal will work fine too, BUT, only for the same version of Jira. If you export from 5.0, then build the new server at 5.0 and import the xml into that.

In theory, an xml import into 6.0 will work, but it's certainly no longer the recommended (or supported) upgrade path and it's almost certain to cause issues unless you have an unusually simple and well-housekept Jira. Move and migrate to Oracle at the same version is safe and supported.

Nic Brough -Adaptavist-

Ah, our comments crossed over! Yes, I was suggesting swapping to oracle at a version that is supported. I'd draw up the version matrix so you know which Jira versions work with which oracle versions. But from memory, I think you could well find it easiest to move to oracle on Jira 5.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration