topic Upgrade from 5.18.0 to 5.20.0 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217196#M170326 <HTML><HEAD></HEAD><BODY><SPAN>This is a similar issue to following topic:</SPAN><BR /><A href="https://forums.activiti.org/content/database-upgrade-script-513-doesnt-alter-schemaversion-table" rel="nofollow noopener noreferrer">https://forums.activiti.org/content/database-upgrade-script-513-doesnt-alter-schemaversion-table</A><BR /><BR /><SPAN>I started with v5.18.0 and wanted to upgrade to v5.20.0.</SPAN><BR /><BR /><SPAN>I executed following scripts from activiti-5.20.0/database/upgrade:</SPAN><BR /><SPAN> activiti.postgres.upgradestep.51800.to.51801.engine.sql</SPAN><BR /><SPAN> activiti.postgres.upgradestep.51801.to.52000.engine.sql</SPAN><BR /><SPAN> activiti.postgres.upgradestep.52000.to.52001.engine.sql</SPAN><BR /><SPAN> activiti.postgres.upgradestep.52001.to.52002.engine.sql</SPAN><BR /><BR /><BR /><SPAN>I wanted to see if there was any difference if I performed upgrade from 5.18.0 to 5.20.0 vs. using create scripts from 5.20.0 (activiti-5.20.0/database/create/activiti.postgres.create.engine.sql, activiti.postgres.create.history.sql, activiti.postgres.create.identity.sql)</SPAN><BR /><BR /><SPAN>The only difference that I can see in the pg_dump is data related (full export of schema and data)&nbsp; is the following:</SPAN><BR /><BR /><SPAN>$ diff pg_dump_create-5.20.0.sql&nbsp; pg_dump_upgrade-5.18.0_to_5.20.0.sql</SPAN><BR /><SPAN>&lt; schema.version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.20.0.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN><BR /><SPAN>&lt; schema.history&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; create(5.20.0.2)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN><BR /><SPAN>—</SPAN><BR /><SPAN>&gt; schema.version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5.20.0.2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN><BR /><SPAN>&gt; schema.history&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; create(5.18.0.0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN><BR /><BR /><BR /><SPAN>Should I manually execute the following SQL, similar to what is seen in the other post I had found?</SPAN><BR /><BR /><SPAN>select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.history';</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>——————</SPAN><BR /><SPAN> create(5.18.0.0)</SPAN><BR /><BR /><BR /><SPAN>update ACT_GE_PROPERTY set VALUE_ =</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;(select VALUE_ || ' upgrade(5.18.0.0 -&gt; 5.20.0.2)' from ACT_GE_PROPERTY where NAME_ = 'schema.history')</SPAN><BR /><SPAN>where NAME_ = 'schema.history';</SPAN><BR /><BR /><BR /><SPAN>select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.history';</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>————————————————</SPAN><BR /><SPAN> create(5.18.0.0) upgrade(5.18.0.0 -&gt; 5.20.0.2)</SPAN><BR /><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Scott</SPAN><BR /><BR /></BODY></HTML> Thu, 14 Jul 2016 20:18:54 GMT sah209 2016-07-14T20:18:54Z Upgrade from 5.18.0 to 5.20.0 https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217196#M170326 This is a similar issue to following topic:https://forums.activiti.org/content/database-upgrade-script-513-doesnt-alter-schemaversion-tableI started with v5.18.0 and wanted to upgrade to v5.20.0.I executed following scripts from activiti-5.20.0/database/upgrade: activiti.postgres.upgradestep.51800.t Thu, 14 Jul 2016 20:18:54 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217196#M170326 sah209 2016-07-14T20:18:54Z Re: Upgrade from 5.18.0 to 5.20.0 https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217197#M170327 <HTML><HEAD></HEAD><BODY><SPAN>Hi Scott,</SPAN><BR /><BR /><SPAN>From an Activiti Engine perspective there's no difference between executing the scripts manually or letting the Engine execute them. The value that matters is the schema.version property. The history has no value for the Engine.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Mon, 18 Jul 2016 09:14:58 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217197#M170327 trademak 2016-07-18T09:14:58Z Re: Upgrade from 5.18.0 to 5.20.0 https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217198#M170328 <HTML><HEAD></HEAD><BODY><SPAN>Thanks so much for the information, Tijs!</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Scott</SPAN><BR /></BODY></HTML> Thu, 21 Jul 2016 18:14:30 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-from-5-18-0-to-5-20-0/m-p/217198#M170328 sah209 2016-07-21T18:14:30Z