How can I migrate historical data of process-instances?

Camunda 7 Topics Discussion & Questions
1

I created two similar process-definitions and using the REST endpoints:
POST /migration/generate
POST /migration/validate
POST /migration/execute
I shifted all current running process-instances to the newer process-definition, the historical data of the process-instances (completed processes) are still associated with the older process-definition, Is there a way I can migrate the historical data as well?

2

There is no option do that. The history was generated based on the prior version of the process model. Some activities may not exist anymore in the new version. That’s why we don’t migrate it. Of course you can use SQL to modify the entries directly in the database, but I would only recommend that if you know what you are doing.

Cheers,
Thorben

3

There’s no structural change as of now in the diagrams, Incase I modify the entries directly in the db, which tables should I look up to?

Thanks in advance,
Udit

4

Hi Udit,

Look at the table ACT_HI_ACTINST and the columns that contain the process definition id and activity id.

Cheers,
Thorben

5

Thanks a lot @thorben.

6