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

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 votes
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 . 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 Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted yesterday in Jira

Upcoming Enterprise releases targeting Q3 2019: Jira Software 8.5 & Jira Service Desk 4.5

Since launching the Jira Software 8.0 and Jira Service Desk 4.0 platform releases in February, many of you have been asking when the next Enterprise release will be so you can take advantage of the m...

284 views 3 7
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