+1, Taher. I will wait for your comment on Jacques question, we already have a document but I think the automated script that can be implemented here. Liquidbase and flyway seem to be promising solutions!
One question always comes to my mind: Can we say that automated scripts will support the migration from last two or at max three known releases? I think we should not put the effort in building the migration script that could migrate ofbiz earlier version(Let's say Ofbiz 10 or 9 or 4) to the latest version. Please share your thoughts on this. Kind Regards Ashish Vijaywargiya HotWax Systems - est. 1997 <http://www.hotwaxsystems.com/> On Wed, Aug 30, 2017 at 7:54 PM, Taher Alkhateeb <slidingfilame...@gmail.com > wrote: > Good idea! Why not take it a step further, and write data migration > scripts? They will serve two purposes in one: 1) document changes 2) > automate upgrades. > > You can experiment with solutions like liquibase or flyway > > On Aug 30, 2017 4:23 PM, "Aditya Sharma" <aditya.sha...@hotwaxsystems.com> > wrote: > > Hello everyone, > > For one of my assignments, I need to find out entity changes that took > place between an older release and the latest release. > > One of the solutions that came up was comparing the database using MySQL > Workbench or some other utility. I found around 60+ new entity changes and > a lot of minor field changes since last big book was published (OFBiz 9 I > suppose). > It's fascinating for me that around 8 years passed since then and data > model still stands well (Kudos to Universal Data Model that we followed in > OFBiz) > > > Just a proposal, since we don't have so many frequent changes in the data > model. It will be good to have a page or some other method defined to keep > a track of such changes. > > I feel such information can be quite helpful when migrating from an older > to some newer release. > > Please share your thoughts. > > Thanks and Regards, > > *Aditya Sharma* | Enterprise Software Engineer > HotWax Systems <http://www.hotwaxsystems.com/> > <https://www.linkedin.com/in/aditya-sharma-78291810a/> >