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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

218 views 0 2
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