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
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,717 views 14 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