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?
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.
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?
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...
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot