[JS2-463] Database Upgrade scripts

• Type: Improvement
• Status: Closed
• Priority: Critical
• Resolution: Won't Fix
• Affects Version/s: 2.0-FINAL, 2.1-dev
• Component/s: Deployment, Installer, Project Build
• Assignee: Unassigned
• Reporter: Scott Weaver
• Created: 07/Jan/06 00:31
• Updated: 27/Nov/06 10:43
• Resolved: 27/Nov/06 10:43

Description

Moving to the release version of Jetspeed 2, I have run into enough database changes to make upgrade fairly painful.

1. The format of the PREFS_PROPERTY_VALUE was completely altered requiring manual migration of existing data from the old table format to the new (see the attached .sql file for example script to move existing prefs).

2. The page statics system was added, not a big deal, but still was suprise and required digging into the logs to locate the issue.

The issue is that on existing build systems I cannot simply wipe/recreate the database like I do on a local dev system and now that we have a release and will try to release incremental builds we should really focus on migration and upgrade scripts for the database.