Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: 2.0
    • Components: Release
    • Labels:
      None
    • Sprint:

      Description

      Most releases of OpenVPMS provide a script to migrate from the previous version to the new version.
      These are located in the <OPENVPMS_HOME>/update/db/ directory and are named migrate-1.x-to-1.y.sql, e.g. migrate-1.7-to-1.8.sql

      To simplify upgrades:

      • a tool should be provided that upgrades the database to the latest version.
      • the web-app should abort if the database hasn't been upgraded

      The upgrade tool will:

      • be based on Flyway. This adds meta-data to the database to track the updates that have been applied
      • will detect the existing version, if there is no Flyway meta-data, and initialise it
      • prompt to run the upgrade if required. In particular, it should warn users that a backup is required before upgrade.

      Flyway does support automatic upgrades, but for OpenVPMS this should be a manual process as it can take a long time.

        Attachments

          Activity

            People

            • Assignee:
              tanderson Tim Anderson
              Reporter:
              tanderson Tim Anderson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 28h
                28h

                  Who's Looking?