http://ofbiz.116.s1.nabble.com/Backup-and-Upgrade-automation-tp170647p170660.html
Yes. They've worked pretty well for us.
> 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 <
[hidden email]> 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?
>>
>>