Migrate from HSQL embedded database to external database in Jira server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Steps
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Before going through those steps, please read the through our Switching Databases documentation.
As in our Connecting JIRA applications to a Database, set up and install one of those DBMS and the JIRA database.
⚠️ Ensure that it one of our Supported Platforms for that JIRA application version.
Schedule downtime with the JIRA users - the use of the Announcement Banner could be employed here.
Back up the JIRA application to XML, as in our Backing Up Data docs.
Shutdown your JIRA application.
Using the JIRA applications configuration tool, connect JIRA to the new database.
Restart JIRA and import the XML backup instead of going through the setup wizard.
ℹ️It is strongly recommended that regular backups are taken in your JIRA application system using your native database backup tools, more on this in the Backing Up Data article.
Was this helpful?