Details
-
Task
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
-
---
-
---
-
2022 Week 26-28 (from Jun 27), 2022 Week 29-31 (from Jul 18), 2022 Week 32-34 (from Aug 8), 2022 Week 35-37 (from Aug 29), 2022 Week 38-40 (from Sept 19), 2022 Week 41-43 (from Oct 10), 2022 Week 44-46 (from Oct 31), 2022 Week 47-49 (from Nov 21), 2022 Week 50-02 (from Dec 12)
Description
The goal of this task is to research possible solutions for handling DB changes over different Kogito versions.
We currently assist users by providing a zip file, which allows users to create the necessary tables for running the runtime and supporting services ( Job Service, Data Index ) in databases like PostgreSQL.
That's fine for creating a new DB but doesn't assist users with changes from a different version of Kogito. For instance, if a new column needs to be added. We recently had these changes on version 1.24.
One option is to consider tools like Flyway or Liquibase which does DB migration automatically, but we can't force users to use that. Specially because lots of enterprises wouldn't allow DB migration to run automatically.
An alternate solution could be to look into how this is done on jBPM v7 where manual scripts are maintained.
Attachments
Issue Links
- is related to
-
KOGITO-7503 [KSW-Guides] How to do data migration with PostgreSQL and Flyway
-
- Resolved
-