...
Having explained about the complexity of migrating workflow engine data out, there is an alternative.
In the case of you find in it important to preserve the audit trail of the part / completed process data, you can enable Process Data Collector at the app level. Process related data of the app would be written into set of tables (app_report_* tables) that can be easily digested for analytical use. However, this plugin would only work on new process data as they are being executed after it is enabled, and not retrospectively on past data.
...
Typically, we will continue to server serve the same set of users in the new server as we scale out.
...