Jira and SQL upgrade

[Leonardo Vasquez]

I have a Jira environment which database is hosted on a server with SQL server 2014. Jira version is 7.9.2 and is fully compatible with SQL Server 2016. I am looking to upgrade SQL instance from 2014 to 2016. 

Do I need to configure something on the Jira server in order to work with the upgrade SQL instance? If I do, what are the steps to configure the Jira server with the upgraded SQL instance?

Thanks 

[Chander Inguva]

Hey Leonardo,

• Stop JIRA Service.
• Make sure you have backups of both JIRA Application and Database data.
• Upgrade SQL 2014 to SQL 2016.
• Make sure the sql drivers are up to date in <JIRA_INSTALL_DIR>/atlassian-jira/WEB-INF/lib
• For any change in db names or credentials, update <JIRA_DATA_DIR>/dbconfig.xml with right data
• Archive all old log files so that you will write all new lines after starting jira service.
• Start JIRA Service
• Monitor log file for any errors you might encounter.
• Log in to JIRA as Admin, check back System info with SQL Version.

Hope this helps

Chander Inguva

[Leonardo Vasquez]

Chander, 

Can I applied the same for the bitbucket server which is on version 5.9.0

Thanks for you reply

Leo.