We are planning to upgrade JIRA to a VM server and move from a mysql to a mssql database. Are there any documentation and instructions on how to migrate? Thanks!
Hey Jessica.
To move JIRA from one database to another you can follow this guide. Also you may want to take a look here as it have some specific configurations needed on MSSQL 2012 to run JIRA.
Hope this helps!
Standard procedure is to explort the database using the XML backup, then import it into an empty Jira pointed at the new database.
See https://confluence.atlassian.com/display/JIRA/Migrating+JIRA+to+Another+Server
(Part of me is curious to know why you're downgrading - there's only one time I'd recommend a move to MS-SQL, just wondering if you fall into that situation, because if you don't, you probably shouldn't be doing this move)
We are currently using JIRA version 4.1.2 with mysql version 5.0.83-community-nt and planning to move JIRA database to mssql 2012. Is there a step by step procedure on how to proceed with this upgrade? We are not trying to do a downgrade. We are upgrading JIRA at same time.
What is the one time move that you recomment from MS-SQL?
Thanks
A move to MS-SQL is always a downgrade, it's simply not as good as Post, My or Oracle. The only time I'd recommend it is when you really don't have any expertise with the other three available. You should always go with what you can support best.
It looks like you're new here. Sign in or register to get started.
