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

[agiteq]

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]

Hi @agiteq - which database are you attempting to connect to? You will have to go to \Application Data\JIRA\dbconfig.xml and change your database configuration. You will also have to restart Jira Service. Please see the link below for additional database connection documentation (if needed): 

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-a-database-938846850.html

Please keep me posted on the status.

Thanks!

[agiteq]

Hi both databases (old and new) are SQL server database.

I was working normally with 2 Jira applications accounts each one on is connected on a separate SQL server database, now I just need to move my database from the old server to the new server.

I tried to edit the configuration with all possible ways but the error still the same (JIRA failed to establish a connection to your database), I tried changing manualy from dbConfig file, and from the Jira Configuration tool, and by deleting the dbConfig file and starting installing jira from first step.

[Thomas B]

@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?

[agiteq]

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]

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.