How to move Jira's database and connect it to another Jira software

Question

Hello,
I have 2 Licenses of Jira software application, both are self hosted on a server (10 users).
and I need to move my database from Jira on server A  and connect it to Jira on server B.

I tried backing up database from Serve A and restored it into server B, and I have a connection error page (JIRA failed to establish a connection to your database.)

Thomas B · Answer

I think that is going to be relatively difficult because sql database structure and table names may not be the same, jira configuration changes or versions may be different. Are you dealing with a large scale of projects/issues?

I would probably do exports from each project, recreate the configuration and then import data from old instance. If you want to merge the two instances, see here: https://confluence.atlassian.com/jirakb/how-to-merge-jira-server-instances-244352137.html

Let me know if this helps.

agiteq · Answer

Yes two Jira instances and I want them to stay on different SQL severs but I need the all the data in instance 1   to be imported to instance 2

Thomas B · Answer

@agiteq - so you have two jira instances that were connected to two separator sql servers but now you want to have two jira instances connected to the same sql server but different databases?