Jira migration

[venkatraj v.p.]

we are planning to migrate jira to a different server and upgrade it to latest jira version.

also we are planning to switch the db from mysql to postgresql during the server migration. will db switching work in latest jira version. Please let us know how we can switch the db contents from mysql to postgresql

[Joe Pitt]

I've run it on postgresql in the past. I suggest you install on the new server, create backup, and import it on the new server. You need to move the attachments if they are on the old server to the new one. If they are on a mapped drive you can just point to them in the JIRA configuration. 

[venkatraj v.p.]

we are also trying to upgrade jira from current 6.3 version to 7.0.

just back up the mysql db and import will work on the new postgresql server which will have jira v7.0? or should we change any other db settings or jira settings

[Joe Pitt]

Read the release notes to make sure there aren't any issues upgrading. Also verify any plugins you have are supported on 7.0. I've done this several times in the past. After installing postgresql have the dba define space for the database. Then configure the new install to point to it. Make sure you have the database driver. Importing the backup will create all the tables, fields, etc. in the database. 

[venkatraj v.p.]

we are changing the db from mysql to postgresql, should we do any data structure level changes in the db or just importing the mysql xml backup in postgresql db will do

[Joe Pitt]

All you need to do is create an empty defined space. Importing the backup will build all the structure.