Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes

>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
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you