Is it possible to do a test restore of a JIRA XML backup?

[Peter Moline]

We are planning to move our JIRA database from one database type to another, using the steps listed here: https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html.

Is it possible to test the XML import without shutting down our existing JIRA instance and deleting dbconfig.xml  - i.e. just run through the database restore process to make sure that the database has been set up correctly?

[Suren Raj]

Hi, Peter.

We can suggest you do the following for testing purpose:

1. Take full backup for Jira (Source)
2. Install New Jira with the same version and configure it with the new database you want to switch to,
3. Once you have completed the installation and start the Jira without any issue, you may restore the backup taken in step 1 to the new JIRA.

[Peter Moline]

So I need a new server to host a new JIRA instance, and have to install JIRA again.
OK, that's not what I would call a test restore, more like complete installation.

Thanks anyway.

[Joe Pitt]

A 'test' would need to be conducted the same as the actual move so yes, you need to install JIRA on the new using the new database product and restore. I don't understand what you're looking for as a shortcut. I've moved servers several times with different JIRA instances and have never had a problem. As long as you're moving to a supported database product there shouldn't be any problems. 

[Peter Moline]

What I'm looking for is a way to validate the backup, and ensure that the new database has the correct settings (collation etc.).

I'm not a DBA and I'd prefer not to have to ask one of our DBA's to work after hours when I'm doing the move.