Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2167

Automate database upgrades

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0
    • Component/s: DSpace API
    • Labels:
    • Attachments:
      0
    • Comments:
      10
    • Documentation Status:
      Not Required

      Description

      Database schema changes are manually applied during DSpace upgrades. In a multi-release upgrade, several SQL scripts must be applied, in order. This is fragile and error-prone. We should pull this into the 'ant update' target so that it can be done consistently and at the right place in the process.

      It may be useful to consider Rails "database migrations" as a model here, and indeed there is at least one Java-oriented DB migration package: http://flywaydb.org/

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              tdonohue Tim Donohue
              Reporter:
              mwood Mark H. Wood
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: