Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Which backup method should I use for a Jira migration with different databases?

Ulrich Krause
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 12, 2020

I need to migrate Jira software from server A to server B.

Server A runs a postgresql database and Jira 8.3, server B runs an oracle DB and also Jira 8.3.

I am confused by the documentation:

here it says:

https://confluence.atlassian.com/adminjiraserver083/migrating-jira-applications-to-another-server-976767611.html

"In this method, you'll need to create an XML backup of your database instead of a native one. That's because the native backup might not be compatible with your new database or operating system." 

Which I understand as: Use the in Jira integrated XML backup-function.

But when I check the documentation about backups it says:

https://confluence.atlassian.com/adminjiraserver/backing-up-data-938847673.html

"For production use, it is strongly recommended that for regular backups, you use native database backup tools instead of Jira's XML backup service."

Does that only count for regular backups or also for these Migration purposes?

 

Which method should I use for my case?

Jira XML backup or DB Backup with e.g. pgadmin4. 

 

Thanks

 

1 answer

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 12, 2020

Regular backups should be done with database tools, as they're faster both to get from Jira and use to recreate a system.

But they're not much use for moving between databases.  The XML export is database agnostic, so it can be dumped out by one Jira, read into another and neither of them care what the underlying database is.

For your migration, run with the XML export.

Suggest an answer

Log in or Sign up to answer