Migration of Jira from One instance to another instance on different server

[Deleted user]

I want to move Jira instance with SQL database from one instance to another instance on different server. So I am hoping to move all the Projects (everything including users) from source to destination server and merge with existing instance. I would like to know what would be the best way to do that and how will I merge SQL databases on two servers.

1. Re Jira instances so far my understanding is that the only way to back up these projects is by exporting Projects in XML using third party addons (like Project Configurator or Configuration manager etc.) and then import these into the destination. Is that correct?

2. I am not sure what is stored in Jira SQL database and what would be the way to move/merge it from source to destination server or will the addon take all the required database in XML file and it will be updated to the destination database automatically at the time of import. 

Any assistance on this matter will be much appreciated. 

[Hernan Halabi - Elite IT Consulting Group · Accepted solution]

Hello @[deleted] welcome to the community. You are right about item one. About the other one, as you import the projects the db will be merged. What won't get migrated as part of it is going to be information related apps you might have in the instance you are moving the projects from. Apps usually have their own table at the db level, I doubt that you can move that from one db to the other and will magically work as expected. Check the apps to see if they have export import capabilities or try to replicate the config manually.

[Deleted user]

Thanks @Hernan Halabi - Elite IT Consulting Group It cleared my doubt.

Regarding the apps, I dont think we are using any apps other than confluence which we will be migrating to the new server (same as Jira) as well. 

[Hernan Halabi - Elite IT Consulting Group]

Good, then the migration shouldn't be too complex