Wednesday, August 31, 2011

In-place database upgrade with Jira 4.4

Today I upgraded our Jira from the relatively old version 4.0 (from 2009) to the newest 4.4 using the steps outlined here. Since Jira 4.3, a 4.0+ database should be automatically upgraded when following these steps.

However all data in our database was cleared when starting Jira 4.4 (fortunately I made a backup). Instead of skipping the Setup Wizard it only skipped the database setup part and prompted me to create a new administrator user etc... for the empty database.

The problem was: in the database settings using the config tool, I used the wrong database schema "dbo" instead of the schema that was used in our database ("jiraschema"). When I restored the backup and used the correct schema the upgrade worked fine!

As a bonus however, the excellent Greenhopper plugin (provides a SCRUM taskboard) is included by default and no additional setup was required to use it.