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: