2010/2/17 Jacobjob Koster <[email protected]>: > Is there any migration script for going from MMBase 1.8 to 1.9 to upgrade > the database types/columns to be compatible with 1.9 and higher?
There is not one script. Such a script may also vary a lot. The syntax may vary according to your database, and nearly every installation would have different tables (and perhaps prefixes). > For example, the cronjobs builder has changed, so the database needs to be > updated too. This doesn't go automatically. I can make queries myself for > every change, but it would be more handy if someone who changes a builder, > also updates a migration script. > A few changes I've seen are in builder: cronjobs, email and object (owner > field) I think it can be considered a bug if the code does not gracefully deal with databases which don't conform yet to updated configuration. Most of the time the impact would be limited to a warning in the log, and perhaps sticking to the old behaviour (like a too short owner field). But indeed it would be nicer if these kind of issues were corrected automaticly. Nicest would be if the storage layer besides detecting the inconsisency also corrected the issue. That was never quite finished. In old versions from MMBase it was more or less implemented, but I think that involved copying entire tables (because informfix didn't support alter tables at all). And nobody ever bothered diving into it any more, because most of the time the alter tables are quite trivial any way. If somebody feels like improving stuff a bit in this area; be my guest :-) > > For CMSc, we make scripts like these: > http://scm.mmbase.org/view/CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt?view=markup > I did however recently add a small feature to be able to associate some code with 'apps1'. http://www.mmbase.org/jira/browse/MMB-1837 More or less a hack, but quite convenient sometimes. Perhaps you could use that to automate some things for a specific applications like CMSContainer. Michiel -- mihxil' http://meeuw.org nl_NL eo_XX en_US _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
