topic Re: Workflow import/export in Alfresco Archive

Workflow import/export

ale_carraro — Tue, 12 Feb 2008 09:48:12 GMT

I did a FULL import/export (ver.2.9), and everything has been imported, except running workflow instances. Any idea on what could be my mistake?thanksAlex

Re: Workflow import/export

mikef — Tue, 12 Feb 2008 13:53:03 GMT

No mistake. Unfortunately full export/import doesn't currently support running workflow instances. You will have to use native database export/import to do this.

Re: Workflow import/export

ale_carraro — Wed, 13 Feb 2008 11:56:43 GMT

My porblem is that I'm doing migration from HSQLDB to Oracle11g. I got to do it so I'm writing what I've done hoping to help someone else in my situation.

1) Do regular Import/Export using Alfresco tools and bootstrap as described in the wiki. Now the destination Alfresco is aligned, except from workflow instances.
2) Disable constraints from destination database
3) Install SquirreSql with the plugins: CopyDb, and the databases that apply
4) Copy the jars of the dirvers if necessary (the hsqldb jar is in the alfresco lib folder..)
5) Create the 2 aliases to the databases (the connection definitions)
6) Use copy db (select any JBPM* table, right mouse button, copy table) from the hsqldb session, select the destination schema and right button, paste tables.
7) Reenable contraints in dest db
😎 Done! Alfresco doesn't even need to be restarted!

Re: Workflow import/export

mikef — Wed, 13 Feb 2008 23:04:18 GMT

This does not provide a direct route from HSQL to Oracle but might help: http://wiki.alfresco.com/wiki/Migrating_from_HSQL