topic Activiti SQL for upgrading from 5.2 to 5.3... in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-sql-for-upgrading-from-5-2-to-5-3/m-p/30041#M15400 <HTML><HEAD></HEAD><BODY><SPAN>Folks-</SPAN><BR /><BR /><SPAN>&nbsp; We use liquibase to manage our database, so I need to create a SQL script for updating from 5.2 to 5.3. For this, I'm planning on just doing the following:</SPAN><BR /><BR /><SPAN>1) Copy the SQL from activiti.postgres.upgradestep.52.to.53.history.sql</SPAN><BR /><SPAN>2) following SQL updates:</SPAN><BR /><SPAN>update act_ge_property set rev_ = 2, value_ = '5.3' where name_ = 'schema.version';</SPAN><BR /><SPAN>update act_ge_property set rev_ = 2, value_ = 'create(5.1) upgrade(5.1-&gt;5.3)' where name_ = 'schema.history';</SPAN><BR /><SPAN>insert into act_ge_property (name_, value_, rev_) values ('historyLevel','2',1);</SPAN><BR /><BR /><SPAN>(Note that the 'schema.history' I'm setting was how it was done in my developer instance.)</SPAN><BR /><BR /><SPAN>Is this correct? Is there a way to execute the activiti upgrade process, but have it printout the pending SQL and not execute it? Is there a better way? (I suppose I could clone my current db to a local instance, turn logging on my db to full, run the upgrade in a local instance, and manually copy the resulting SQL to a liquibase script…)</SPAN></BODY></HTML> Thu, 03 Mar 2011 18:38:09 GMT wolpert 2011-03-03T18:38:09Z Activiti SQL for upgrading from 5.2 to 5.3... https://connect.hyland.com/t5/alfresco-archive/activiti-sql-for-upgrading-from-5-2-to-5-3/m-p/30041#M15400 Folks-&nbsp; We use liquibase to manage our database, so I need to create a SQL script for updating from 5.2 to 5.3. For this, I'm planning on just doing the following:1) Copy the SQL from activiti.postgres.upgradestep.52.to.53.history.sql2) following SQL updates:update act_ge_property set rev_ = 2, valu Thu, 03 Mar 2011 18:38:09 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-sql-for-upgrading-from-5-2-to-5-3/m-p/30041#M15400 wolpert 2011-03-03T18:38:09Z Re: Activiti SQL for upgrading from 5.2 to 5.3... https://connect.hyland.com/t5/alfresco-archive/activiti-sql-for-upgrading-from-5-2-to-5-3/m-p/30042#M15401 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Indeed, eg. the file/activiti-engine/src/main/resources/org/activiti/db/upgrade/activiti.oracle.upgradestep.52.to.53.history.sql contains script that is executed when upgrading history from 5.2 to 5.3. This can also contain Java-steps (eg. execute java org.activiti.engine.impl.db.upgrade.DbUpgradeStep52To53InsertPropertyHistoryLevel).</SPAN><BR /><BR /><SPAN>By combining all scripts (history, engine, …) + java-steps for your DB, you can see what happens in the upgrade. Offcourse, the java-steps may contain additional logic that cannot be translated to SQL, but as long as you can translate it, this is the only way to upgrade manually (although not recommended).</SPAN><BR /><SPAN>There is currently no way of doing a "dry run" which just prints out the updates.</SPAN></BODY></HTML> Fri, 04 Mar 2011 07:07:54 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-sql-for-upgrading-from-5-2-to-5-3/m-p/30042#M15401 frederikherema1 2011-03-04T07:07:54Z