Migrating to Activiti BPMN

[justass]

Hello,

  we are implementing new system using Activiti and there is a requirement, to migrate all historic data from the old system. What would be the best way to perform migration?
  For example, there is a Activiti bpmn process to issue some kind of licence. When the process is executed, I can collect all historic (applicant name, licence issue date, revocation date, etc) data using Activiti history service.  And there is historic data in legacy system, which must be migrated to the new system based on Activiti. Any recommendation, how it might be done? Writing sql statements and inserting data directly to act_hi_* tables doesn't look like a good approach..
Thanks.

[pmsevestre]

Assuming you can map all historic data from the old system to activiti, I don´t think stuffing act_hi_* tables with all that data is too bad, since it´s a one-time task after all.

One thing that you can do in order to easily find old instances is to use a different process version for them. Just deploy your new process twice, and use the first  process id that you can use as a basis to populate historic tables.

[martin_grofcik]

Hi,

In case when it is not possible to map legacy data to the ACT_HI_* tables you can:
1. Keep data in legacy system and get history from the legacy system before it is archived.
2. Extend act tables to support your needs.

Regards
Martin