Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

agiteq May 13, 2019

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.)

1 answer

0 votes
Thomas B
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 13, 2019

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 May 19, 2019

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 23, 2019

@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 May 23, 2019

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 23, 2019

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. 

Suggest an answer

Log in or Sign up to answer