portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott T Weaver (JIRA)" <jetspeed-...@portals.apache.org>
Subject [jira] Updated: (JS2-463) Database Upgrade scripts
Date Fri, 06 Jan 2006 15:35:17 GMT
     [ http://issues.apache.org/jira/browse/JS2-463?page=all ]

Scott T Weaver updated JS2-463:

    Attachment: migrate.sql

Migration script (MSSQL Specific)

> Database Upgrade scripts
> ------------------------
>          Key: JS2-463
>          URL: http://issues.apache.org/jira/browse/JS2-463
>      Project: Jetspeed 2
>         Type: Improvement
>   Components: Deployment, Installer, Project Build
>     Versions: 2.1-dev, 2.0-FINAL
>     Reporter: Scott T Weaver
>     Priority: Critical
>  Attachments: migrate.sql
> 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.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org

View raw message