nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

PostgreSQL Vs MS SQL server for Jira 8.6

Vijay_Ganji

We have a choice of staying on PostgreSQL database for Jira 8.6.1 or move to MS SQL server, which one do you guys prefer if given choice.

Accepted answers

Postgresql!

If there is a choice, I always prefer the same platform (OS, Java, database, etc) the application provider uses for development. I call these tier one platform elements as they are most often what the provider's development and support staff are most familiar with. This frequently translates into better application stability and performance plus faster turn-around for support issues.

In this particular case

There are the the reasons above
There will likely be a significant license cost increase to move to MS-SQL
There will likely be a non-trivial amount of "administrator" time/cost increase to move to MS-SQL

Hope this helps and if it does, please click the "Accept Answer" button so others searching for this info see the "answered" flag in their search results.

Cheers!

All comments

repi

@Vijay_Ganji

Postgresql!

Vijay_Ganji

Thank you Repi, Do you have few reasons from your experience why, so i can tell my management and recommend PostgreSQL

repi

@Vijay_Ganji

Most important reason, postgresql is not from microsoft.

Postgresql is probably cheaper than mssql

https://www.datacamp.com/community/blog/sql-differences

https://www.trustradius.com/compare-products/postgresql-vs-sql-server

LarryBrock

Hi @Vijay_Ganji

In this particular case

There are the the reasons above
There will likely be a significant license cost increase to move to MS-SQL
There will likely be a non-trivial amount of "administrator" time/cost increase to move to MS-SQL

Hope this helps and if it does, please click the "Accept Answer" button so others searching for this info see the "answered" flag in their search results.

Cheers!

Vijay_Ganji

Thank you Repi and Larry,

I think we have some direction on this.

Great to have this community

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

postgres