Inplace SQL 2008 upgrade

[Travis Sinohui]

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

[Colin Goudie]

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

[Radu Dumitriu]

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 ?