I've been tasked with merging data within our webapps databases, including the ACT_* tables between two separate databases.
Has anyone attempted something like this on the ACT_* tables before?
I am currently reading the Activiti user guide to get a better understanding of the data flow between tables during a process.
What concerns me is that there are tables without any referential integrity constraints within the DB, and json objects that hold data that should have referential constraints. I am aware that resequencing will be required for some fields, which fields in particular that are not apparent just by observing at a database layer. Any guidance would be appreciated .