Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-32605

Improved database migrations

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 12.0
    • Fix Version/s: None
    • Component/s: Global
    • Labels:
      None

      Description

      At the moment database migrations are done with SQL scripts that are run between each major upgrade. This is error prone and means developers regularly have to clean out databases or manually go and find SQL migration code when working on the master branch.

      `auto.ddl` takes care of new tables but this doesn't help for changes and refactorings to existing tables. Also when the migration needs to involve Java code (as in the migration of favourite sites) custom solutions are developed each time.

      We should look at using a database migration tool such as liquibase or flyway to make these database migrations easier.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  buckett Matthew Buckett
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Git Source Code