topic Re: 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/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 frederikherema1 2011-03-04T07:07:54Z 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