Are you talking about the sql files? I was thinking services that can provide log output so that the upgrade can be monitored. In addition, I'm not sure sql provides enough logic especially as foreign key relationships change. Have any of the upgrades been complex yet?
--- Si Chen <[EMAIL PROTECTED]> wrote: > We already provide these for opentaps releases. You > can download the > scripts off sourceforge.net > > On Aug 14, 2006, at 1:24 AM, Chris Howe wrote: > > > I was brainstorming what would be necessary to > create > > an Upgrade service in OFBiz for improvements in > OFBiz > > that break backwards compatibility. > > > > the requirements that I've come up with are the > > following > > 1) Backup the database (an upgrade script may > break or > > corrupt the database) > > 2)Check the upgrades that are necessary to run the > > version (svn) that is trying to run > > 3)compare to list of upgrades that have already > been > > done > > 4)Copy the old entities to tempTables > > 5)Create the new tables necessary for the upgrade > > 6)Run a script to process the data into it's new > > structure > > 7)Drop the tempTables > > 8)enter the upgrade script name into the list of > > upgrades that have been done > > > > Am I missing anything? Anyone else interested in > > something like this? > >
