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
Community showcase
Published Mar 14, 2019 in Jira

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

552 views 1 14
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