Uploaded image for project: 'Dashboard'
  1. Dashboard
  2. DASH-313

Dashboard could use a way to manage future database migrations

    XMLWordPrintable

    Details

    • Type: Task
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 11.0
    • Fix Version/s: None
    • Component/s: DAO and SQL
    • Labels:
      None

      Description

      Looking at the code, if auto.ddl is set to true, it tries to create all the tables. If the tables exist, the initTables will fail and nothing will run. It would be nice if Dashboard had some way to perform migrations for the future when/if columns and tables are added in future versions without requiring a user to run SQL scripts.

      This is generally accomplished with hibernate in most tools other than the oldest ones that still require sql scripts. It could also be done with just liquibase. We could do it with a tool like flyway or liquibase. But if we really did something like this it might be better to do it for all of Sakai in general to make conversions easier. So maybe this isn't just a dashboard-only issue.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  maintenanceteam Core Team
                  Reporter:
                  jonespm Matthew Jones
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated: