Uploaded image for project: 'Kogito'
  1. Kogito
  2. KOGITO-7676

Implement Flyway DB schema migration for Postgresql

    XMLWordPrintable

Details

    • 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 provide users with a way to migrate the SQL databases when there's a change with the Kogito upgrade.
      Users should have the option to migrate the DB at start-up or manually using Flyway CLI.

      Flyway has a property `quarkus.flyway.migrate-at-start`, which can be used by users to allow migration on start-up. 
      There should be documentation on how to use flyway to migrate the DB manually to have more control. 
      There could be a case where users don't want to use flyway, in that case documentation should be provided for executing SQL scripts to create schema manually.

      Attachments

        Issue Links

          Activity

            People

              abkuma abhishek kumar
              abkuma abhishek kumar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: