Switching Databases

JIRA's data can be migrated between different databases on the same database server, to the same database type on a different server (e.g. from one PostgreSQL server to another PostgreSQL server) or to a different type of database server (e.g. from a MySQL server to a PostgreSQL server).

To do this, follow the appropriate procedure:

Migrating JIRA's Data to the Same Type of Database

Use this procedure to migrate JIRA's data to:

• A different database on the same database server, or
• The same database type on a different database server (e.g. from one PostgreSQL server to another PostgreSQL server).

To migrate JIRA's data to the same type of database:

1. Use your database server's native tools to either:
   • Copy your JIRA database to a new database on the same database server installation, or
   • Copy/migrate your JIRA database to a new database of the same type on a different database server installation.
     Please Note:
     • If you are unable to do either of these tasks, use the Migrating JIRA's Database to a Different Type of Database Server procedure (below) instead.
     • You could use this procedure to migrate JIRA's data to a different type of database server (e.g. MySQL to PostgreSQL). However, you would need to find tools that support these processes. Furthermore, Atlassian does not provide support for this strategy.
2. Once your new database has been populated with JIRA's data, shut down your JIRA server.
3. Make a backup of your JIRA Home Directory and JIRA Installation Directory.
4. Reconfigure your JIRA server's connection to your database:
   • If you are using JIRA Standalone, you can use the JIRA Configuration Tool (by running bin/config.sh (for Linux/Solaris) or bin\config.bat (for Windows) in your JIRA Installation Directory), which provides a convenient GUI that allows you to reconfigure JIRA's database connection settings.
   • If any of the following points applies to your situation, you need to manually configure the dbconfig.xml file in your JIRA Home Directory. Refer to the appropriate database configuration guide in the Connecting JIRA to a Database section for the manual configuration instructions.
     • You are using JIRA WAR
     • You have a console-only connection to your JIRA server
     • You would prefer to configure your database connection manually (for custom configuration purposes).

Migrating JIRA's Data to a Different Type of Database Server

Use this procedure to migrate JIRA's data to a different type of database server (e.g. from a MySQL server to a PostgreSQL server).

1. Create an export of your data as an XML backup. See Backing Up Data for details.
   Please note that JIRA's XML backup utility does not back up attachments (if you have attachments enabled).
2. Create a new database on your new database server to house JIRA's data. See the appropriate database configuration guide in the Connecting JIRA to a Database section for the database creation instructions.
3. Shut down your JIRA server.
4. Make a backup of your JIRA Home Directory and JIRA Installation Directory.
5. Delete the dbconfig.xml file in your JIRA Home Directory.
6. Restart JIRA and you should see the first step of the JIRA Setup Wizard for configuring your database connection.
7. Configure JIRA's connection to your new database (created in step 2 above) and click the 'Next' button.
8. On the 'Application Properties' setup page, click the 'import your existing data' link and restore your data from the XML backup created in step 1 above.