topic Re: Activiti ACT_* Table Merge in Alfresco Forum

Activiti ACT_* Table Merge

ammark — Thu, 28 Nov 2019 05:26:00 GMT

Hello all,

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 .

Re: Activiti ACT_* Table Merge

gkorman125 — Tue, 29 Sep 2020 23:26:05 GMT

Any chance you ever found a way to do this? I'm in a simular situation trying to merge two databases. One that is a restoration of a lost database, and the other is the work done in the meantime.

Thank you.

Re: Activiti ACT_* Table Merge

EddieMay — Wed, 30 Sep 2020 10:10:22 GMT

Hi @gkorman125

Have you raised a support ticket?

Cheers,

Re: Activiti ACT_* Table Merge

gkorman125 — Wed, 30 Sep 2020 10:18:27 GMT

We have not. Time is short, since this for a customer and in production. I know the database structure, and I will have to do SQL scripts based on the specific data. The order of table population is enforced by the foreign key constraints, so I think I'm in good shape. I was only hoping for a tested method.

Re: Activiti ACT_* Table Merge

EddieMay — Thu, 01 Oct 2020 09:19:24 GMT

Hi @gkorman125

Back up, back up, & then back up the database some more Good luck.

Cheers,