Community
Products
Jira
Questions
Inplace SQL 2008 upgrade

Inplace SQL 2008 upgrade

Hi,

We have JIRA 4.0.1 on a server that then connects to a SQL server for the database. The SQL server currently runs SQL 2005. We need to upgrade that to SQL 2008. Can we do an inplace upgrade? If not how do we do we accomplish this?

thanks,

Travis Sinohui

KIC

IT Manager

858-945-7237

2 answers

0 votes

Yeah I don't see an issues (TEST FIRST though)

Backup you SQL 2005 database, and then do a restore into a SQL 2008 instance.

Then change the new databases compatibility level to be 2008 - http://msdn.microsoft.com/en-us/library/bb510680.aspx

Then adjust your database settings in JIRA to point to the new database and boot JIRA

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Replicate your env on a virtual machine you can scrap anytime and do a test. IMHO, you should not have any problems, but who knows ?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Product Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

Inplace SQL 2008 upgrade

2 answers

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events