Migrate activiti Oracle to postgres

[darshan_hardas]

Hi Folks,

We have been using Oracle DB for activiti which we now want to migrate to Postgres. Can you please help me if any scripts available to do this migration of schema.

We already have executed oracle scripts on Postgres and the table has now got generated.We need to run the delta which can change the oracle-specific schema to Postgres compliant. Any inputs?

Thanks in advance.

[jbarrez]

I don't have any resources that could help you with that … it's probably not that hard, but there might be some tricky data type conversions along the way :s

Maybe there is some tooling availabile in things like Liquibase to get the data to an intermediary format?

[darshan_hardas]

Thanks jbarrez.
We are using liquibase, let me check the tables data to desired format.