Camunda data migration from Oracle to PostgreSQL database

Camunda 7 Topics Discussion & Questions
1

Hi Team,

We have multiple processes in Oracle(19c) database. Now we planning to migrate all the runtime+historic data to PostgreSQL(v14) database along with all the running instances and deployments.

Camunda BPM: (v7.12.0)
Camunda BPM Spring Boot Starter: (v3.4.1)

Please suggest the best feasible method to perform this activity.

Thanks Team.

2

Hello @Ingo_Richtsmeier , could you please share your suggestions. which tool or method we can use to migrate all running instances + history data from Oracle to PostgreSQL.

3

Hi @jsprt,

I’m not a database expert and don’t know any tools in this area.

The Camunda engine uses JDBC to access the database and supports several database vendors. With this, as data migration is possible, and I’ve heard from several enterprise customers who did this. But I don’t know how to do it.

The best way to get a solution would be to approach the database vendor of your target system. They have the biggest interest to support you.

To remove the leftover from completed process instances, use the history cleanup before. Set the removal time to now with this batch: Set Removal Time Async (POST) | docs.camunda.org and then start the cleanup: History and Audit Event Log | docs.camunda.org

Hope this helps, Ingo

4