Improve installer to include migration scripts and syncApplied

Description

Suggested to improve installer to include migration scripts and a core version of the syncApplied script

Environment

None

Activity

Carlos Ruiz March 15, 2018 at 2:22 PM

great - thanks for the feedback

Dirk Niemeyer March 15, 2018 at 10:05 AM

Hi
same with oracle db. Just ran the steps you listed.
Great enhancement. Thank you!

Carlos Ruiz March 14, 2018 at 10:53 PM

Just tested running this on demo.globalqss.com:

sudo /usr/sbin/service idempiere stop
cd /opt/idempiere-server
sh update.sh http://ci.idempiere.org/job/iDempiere5.1/ws/buckminster.output/org.adempiere.server_5.1.0-eclipse.feature/site.p2
cd utils
sh RUN_SyncDB.sh

it worked perfect!!!

Carlos Ruiz March 14, 2018 at 9:23 PM

Committed an implementation of this idea as this:

  • the migration folder is now included in the installer

  • old migration folders were moved in repository to a new folder migration-historic - just folders >= i4.1 were preserved in migration, so, just since these folders will be included in new installers

  • added two folders in migration as a hint for people to use them: local_sql and zip_2pack

  • local_sql is intended to add custom sql migration scripts

  • zip_2pack is intended to add 2pack files - they will be processed by the automatic packin installer

So, now the process to install or upgrade a server is something like:

console-setup.sh
cd utils
RUN_ImportIdempiere.sh
RUN_SyncDB.sh

I tested in postgresql.

Can somebody please help to test in oracle? Maybe or ?

Windows version of the script is not developed, just linux.

Fixed

Details

Assignee

Reporter

Priority

Created March 14, 2018 at 3:33 PM
Updated May 1, 2018 at 1:46 PM
Resolved March 14, 2018 at 9:23 PM