We're updating the issue view to help you get more done. 

Database upgrade tool

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.

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Components

Fix versions

Priority

Major