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

Migrate JIRA H2 to MsSQL - failing for queues and reports Edited



We have a test install of JIRA / Service Desk which is using the internal H2 database . We now wish to transfer the data to our SQL server install and have followed the steps for migrating to a different database.

We have tried on the same server, as well on a test environment and whilst it all appears to work OK, we are missing data in each test we have done.

The H2 database is quite large (+8Gb) and the backup file that gets geneated is 1.3Gb.

Most of our JIRA issues etc are showing OK, but our Service Desk custom queues are always missing.  Also missing are all our custom reports.

Is there any other method to export data from the H2 database?  Especially given that the SQL Server is running with the necessary tables.


In terms of data, the table AO_54307E_QUEUE on SQL shows the 4 queues:

Due soon
SLA breached
SLA at risk
My open tickets

however the H2 database has 60 rows of data.


1 answer

1 vote

>"Is there any other method to export data from the H2 database?"

No.  You need to do a full export/import.

... so when that doesnt work ... there is no other option :(

An 8Gb "test" system stopped being "test" around 7.9Gb ago.  You should have moved to a proper database as all the documentation said at the time.

Exporting it to XML so you can import it into a real database  really is the best option, and possibly the only one.

So, going to look at the actual problem.  "... so when that doesnt work ..." tells us nothing about it.  For all we know, it has not worked because a penguin wandered into your office and bit the network cable part way through, or something equally silly.  Please explain the actual problem with the migration, then we might be able to help.

Thanks for the reply, but dont shot the messenger.  It wasnt my call to use the Internal DB, Im merely being asked to step in at tooo later stage!

As above, I thought I had posted some information.  If there wold be something specific , then just lt me know ,... but please drop the sarcasm!

From all I can see it "has worked", except when the staff go to use it they say, as I have noted above, that the Custom Queues and Custom reports dont exist.  Everything else, by all observation, is OK.

Thanks for your help,  but maybe we will have to backout and look at another product.

I wasn't intending to come across as sarcastic, just light-hearted.

An export/import will carry over all your data, so I can't tell what's going wrong.  You've said "it doesn't work", but that doesn't tell us what is wrong.  Is it just the queues and reports?  I can't work out a way to loase those when you're doing a plain export/import.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

1,130 views 1 13
Read article

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