JIRA Database switch query

[Sanu Soman]

Hi All,

We have two JIRA instance running like, JIRA A with HSQL and JIAR B with oracle DB1.. both having same data.

Now I want to change the DB for these JIRA instance like, JIRA A has to connect DB1 and JIRA B to new oracle DB ie DB2? Please suggest the best way to do this.

Is it possible to simply change HSQL to Oracle DB1 for JIRA A by editing dbconfig.xml file? Is this will work? or JIRA everytime look for empty DB?

Many thanks in advance :)

[Timothy · Accepted solution]

If both JIRA A and B are the same version, you can just swap the dbconfig.xml and perform a reindex. You might want to make sure that the plugins exist on each of the instance and is the same version.

[Timothy]

So I can go ahead with changing dbconfig.xml file... right?

Sure, if you are afraid, make a backup of your Oracle DB and copy your HSQL database folder.

[Sanu Soman]

Do I need to restart the JIRA service for this? Or simply editing dbconfig.xml to map second DB will work? please advise.

[Teck-En]

You would have to shutdown the service, edit the dbconfig.xml and restart to ensure JIRA point to the new database.

[Sanu Soman]

Yes.. both instance are having same version.. only difference is DB. So I can go ahead with changing dbconfig.xml file... right?

[Teck-En]

It shouldn't be problem if both are using the same version. Timothy has a point there which you need to backup the directories as a precautions. From Atlassian point of view, we would suggest the XML import method instead: https://confluence.atlassian.com/display/JIRA060/Switching+Databases#SwitchingDatabases-differenttype