JIRA / Confluence Migration

[Faisal Shamim]

Hi,
I have to do JIRA Migration of 2 jira instances . Here is the details:
Both Version v7.2.8
Source JIRA DB: mssql ; Server : Windows : Windows Server 2012 R2 6.3
Target JIRA DB: Oracle ; Server OS : Linux : Red Hat Enterprise Linux 6.5

Please guide me steps how to do migration and what are pre-requisites.

Thanks,
Faisal

[Eugene Chernyi]

Hi,

In case migration from SQL db to Oracle db

Before you start create a full backup of your data(Database, JIRA home directory, JIRA installation directory )

For Jira:

If you want to change database without changing Jira server:

1. Create an XML backup 

2. Create a new database on new server :  Connecting Jira applications to Oracle

3. Stop Jira service.

4. Delete the database configuration file:  JIRA home directory dbconfig.xml

5.Start Jira service and you will see JIRA setup wizard where you need to connect to the new Oracle database which you created (step 2). 

6.Restore your data from XML backup. Restore from XML backup 

if you want to change database and Jira server:

1. (OldServer) Create an XML backup

2. Create a new database on new server : Connecting Jira applications to Oracle

3. (OldServer) Stop Jira service.

4. (OldServer) Create a backup of JIRA home directory, JIRA installation directory

5. Move backup (step 4) to the new Jira server

4. (NewServer) Delete the database configuration file: JIRA home directory dbconfig.xml

5. (NewServer) Start Jira service and you will see JIRA setup wizard  where you need to connect to the new Oracle database which you created (step 2).

6. (NewServer) Restore your data from XML backup. Restore from XML backup

[Nic Brough -Adaptavist-]

Is this a migration (just moving from one server to another), or a merge (existing projects in the source will be added alongside existing projects in the target)?

[Faisal Shamim]

This is a migration of JIRA & Confluence from from SQL db to Oracle db