Copy active executions to different db

[mpradny]

Hi,

we want to copy active executions (and all related data) to different database. Is there some way that activiti API can help us? I have found API pro deleting, but not for copying. The selection key would be deployment.

We have shared workflow engine for multiple applications with multiple processes. Now we want to copy data for one of those application into our test environment, so users can test new release and we can test instance migration. Since we have execution ids in business data in separate database, we need to keep them.

Only way how I can imagine this is to split workflow engines and have separate database tables for each application. Then we would be able to simply copy database that is used just for the application. Split can be done quite easily, is we copy full current db and then delete deployments that are not related to current app.

Is anyone doing Live -> Test environment copies with Activiti?

Martin

[ronald_van_kuij]

why can't you just copy all data? Size issue?

[mpradny]

Because other apps might be in different phase of testing, so we need to keep them.

Let's say we have apps A, B, C in production. At first we can copy data of all to test, but if testing of A is then in progress and executions might have changed, we would need to replace data for B and keep A data as they are.

We have to have all apps on same server in test environment since we need same configuration as in production.

M.

[nizar]

Hi ,
Any solution for this problem ?

[trademak]

Hi,

Why not copy all the data to the other database? Why only the executions?

Best regards,