Migration from hsqldb to ms sql 2012 but where are agile boards?

I migrated JIRA data from hsqldb to ms sql 2012 but my agile boards didn't get migrated. I am assuming that the board data is stored someplace else. Would you be able to tell me how I can get the Boards over to my production system? We are using JIRA 6.3.12.




1 answer

0 vote
Pedro Souza Atlassian Team Jan 09, 2015

Hello Kathy,

Could you please clarify how did you perform the migration, did you exported an XML Backup while using HSQL, then started JIRA connected to ms sql and performed the import?

If you exported the XML Backup, the boards should be present in the file activeobjects.xml, and it should have been imported to your system if you have restored the .zip file containing the entities.xml and activeobjects.xml.


Please, clarify if you have imported only the entities.xml instead of the .zip containing both files.


Hi Pedro

I used the steps of Migrating JIRA's data to a different type of database server–steps found https://confluence.atlassian.com/display/JIRA/Switching+Databases . I have a situation where developers thought they we in production and created projects on the evaluation system and now they need the data in production. Attachments didn't import either but I found the attachments folder and copied the folder contents to the production server, rebooted and the attachments are good.




I did just copy the entities.xml. I tried copying the other file in the folder and I couldn't. Was I just suppose to import the .zip file? And if so how can I now just get the boards?




Pedro Souza Atlassian Team Jan 09, 2015

Hi Kathy, Actually you have to import the zip file containing the entities.xml and activeobjects.xml in the root of the file. The entities.xml will contain your JIRA data, and activeobjecs.xml information originated from any plugin, since you didn't imported the activeobjects, you won't have any information from your plugins in this instance (such as Agile information). Please, take a moment to compress both files in a single .zip, and perform the import again. Cheers.

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

592 views 6 10
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot