Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA upgrade from 7.13 to version 8.13.2. integrated with MMSQL Server DB 2016R2 SP2

i , 

we are planning to upgrade JIRA from version 7.13 to version 8.13.2 . The Database used  is MSSQL 2016R2 SP2. and the JDBC driver used is version 6. do i need to upgrade the driver while doing the upgrade to version 7 , or the database is supported for version 8.1.3.2

1 answer

0 votes

Hi @sujata Birajdar ,

please check the below screen shot for 8.13,2  compatibility for SQL SERVER

image.png

Hi Kagithala, 

I am aware of this supported platform details page. My query is do i need to update the JDBC driver before the upgrade or while doing the upgrade i can update it , or the driver will automatically get updated . 

Hi @sujata Birajdar ,

You need to download Microsoft JDBC 7.21 driver.

After DB Upgrade you need to place the updated driver in the following path.

and place in the following location

<JIRA installation directory>/lib/

Note: Please check in Staging First  DB Server first. keep the production as same.

Hi, 

we dont have staging environment as such and we are planning to upgrade our production instance directly. bt i didnt understand why there is a need to upgrade the database . 

the database we have currently is 2016R2 SP2 MSSQL server , Could you please confirm if this is compatible with version 8.13 as in the supported platform only the 2016 SQL server is mentioned . 

we though only updating the driver will work or do we need to upgrade the DB as well for the JIRA upgrade.

Hi ,

Me just populated the first screenshot only to show which DB is compatible for Jira.

There is no need of Upgrading Database.

I think you only need to use they mentioned Database driver , which is Microsoft JDBC 7.2.1.

Thank for the update Kagithala .

the JDBC driver needs to be updated while doing the JIRA upgrade or before the upgrade also we can update the Driver and proceed with the JIRA upgrade to version 8.13.2 .

what is the expected approach.

After DB Upgrade.

Before Starting Jira Service is my suggestion.

After DB upgrade? 

since the Database used is the supported platform for 8.1.3.2 i dont think there is a need to upgrade DB , 

so as per your suggestion we should update the driver while doing the upgrade of JIRA to version 8 1.3.2. but before starting the JIRA service.?

Sorry , i was in same thinking of Upgrading DB. 

Please paste Database driver before starting the Jira Service.

Sorry for the trouble.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.13.0
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,120 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you