Set up Cloud-based JIRA importing SQL JIRA backup

This question is in reference to Atlassian Documentation: Importing issues from JIRA server applications

We used JIRA server until the recent servers migration in our company. We have SQL backup file (.bak) of our JIRA database. Do we have to restore JIRA on the new server and then migrate it to the Cloud? Or can we just set up the Cloud-based JIRA and import our database there?

1 answer

This widget could not be displayed.

>Do we have to restore JIRA on the new server and then migrate it to the Cloud?

Yes.  Cloud needs an XML file exported from a recent version of JIRA.  You don't have any access to the database, your SQL is of no use to Cloud.

Thank you! This is very helpful.

So I've installed JIRA server in the new place and restored JIRA database from another server backup. How do I connect the one with the other?

 Do I have to modify this line in dbconfig.xml? How should I change it? What else should be done except to JIRA service restart?

<url><url>jdbc:h2:file:C:\Program Files\Atlassian\Application Data\JIRA/database/h2db</url>




I'm not sure that alone will work, as you're changing database type.

What I would have done is to create a new empty database, and set up the new JIRA against that.  That way, you know you have a working target system.  Then you'd stop JIRA, change the dbconfig file to point at the restored database, and restart it.

You can still change the dbconfig file, but you might find failures about missing drivers and versions of things.  It's worth a try (worst case, if you want to go back to my method - remove the content of the JIRA home directory, and your JIRA install will go "hey, I'm new" and start fresh)

 

Thanks. A new empty database and the dbconfig adjustment finally did the trick.

 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

44 views 4 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you