Uploaded image for project: 'Jetspeed 2 (Retired)'
  1. Jetspeed 2 (Retired)
  2. JS2-463

Database Upgrade scripts

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Critical
    • Resolution: Won't Fix
    • 2.0-FINAL, 2.1-dev
    • None
    • Deployment, Installer, Project Build
    • None

    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.

      Attachments

        1. migrate.sql
          1 kB
          Scott Weaver

        Activity

          People

            Unassigned Unassigned
            weaver Scott Weaver
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: