Upgrading to JIRA Software caused database switch to internal HSQL

I recently upgraded from JIRA 6.2 to JIRA Software, and a few days after, I noticed that JIRA is using the internal HSQL database.Originally, our database was SQL Server.

Now, per the link, https://confluence.atlassian.com/jira/switching-databases-185729500.html#SwitchingDatabases-differenttype, it should be straightforward to reconfigure JIRA to use SQL Server, instead of HSQL. (Scenario 3)

My question is, if I follow the steps to switch the database, upon restoring the backup, will the data from HSQL (over a few days of JIRA Software use), be appended to the original SQL Server database?

2 answers

Yes Rajat, As long as you have all plugin-data before Upgrading it to JIRA Software like script runner scripts/ custom codes and a valide License for JIRA Software, switching databases should retain all the information

Thanks for the response. Just to reiterate, here is the sequence of events followed: 1. JIRA 6 used SQL Server 2. I performed the upgrade to JIRA Software and restored the backup about 10 days ago. 3. After the upgrade, JIRA Software appears to be using HSQL 4. I need to switch back to SQL Server, ensuring that all the data generated over 10 days gets appended to the original SQL Server instance.

Good. Please ensure you try the steps suggested in the above link on Dev environment first, document all the steps you performed and later do it on Production. Data is always *Valuable* Good Luck!

The steps described in https://confluence.atlassian.com/jira/switching-databases-185729500.html#SwitchingDatabases-differenttype are exactly the correct ones to take to move between two different database systems.

You will of course be testing this in a development environment before you do it on your live environment?

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Mar 17, 2018 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...

618 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