Guys do you have database recommendation to JIRA ? We intend to use MySQL here, but we have Oracle 10g and MSSQL 2005 in our enviroment.
PostGreSQL first, MySQL second, Oracle third, Microsoft SQL server fourth.
Atlassian strongly recommend PostGreSQL, but as I read between the lines, MySQL is a pretty close second at the moment. You can make it work with all sorts of other databases too, but those are the four that Atlassian officially support, so I wouldn't run with another one unless you have a strong reason to do so.
Personally, I'd like to add that all of the databases I've used with Atlassian software (Think I'm on 9 or 10 now) have quirks, but the only one that's been a monumental pain in the fundament is MS SQL. I'd rather support Jira on a file/ISAM based system. Or post-it notes.
If you have to get into a fight about which SUPPORTED one to use, then I would actually say "whichever your organisation is most familiar with" (but not MS), as it's pretty close.
Oh - and versions - use the latest whenever you can. But, again, what your organisation is happiest with is better. Always check https://confluence.atlassian.com/display/JIRA/Supported+Platforms first.
Thanks Nic !
Nic, Just curious. What issues or type of issues have you run into using MSSQL?
It looks like you're new here. Sign in or register to get started.
