Jira migration

Question

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 · Answer

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

venkatraj v.p. · Answer

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 · Answer

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.