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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


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


Mime
View raw message