Jira and SQL upgrade

Question

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

Leonardo Vasquez · Answer

Chander,

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

Thanks for you reply

Leo.

Chander Inguva · Answer

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 /atlassian-jira/WEB-INF/lib * For any change in db names or credentials, update /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