sqadm upgrade-data(1)

sqadm upgrade-data - Upgrade Squore data

sqadm upgrade-data [-v] [--patch] [-S dir] [-D dir] [--explain] [--until version] [--jdbc-url url] [--jdbc-user user] version

This command upgrades Squore data.

The sqadm upgrade-data command shall be executed on a stopped Squore server, but a running database.

--patch

Apply specified patch only.

A patch version is of the form: `x.y.z_n', where `x.y.z' is a Squore version, and `n' the patch number.

-S, --sql-dir dir

Directory with SQL scripts to upgrade schema.

-D, --data-dir dir

Directory with Squore projects files (<SQUORE_DATA>/projects).

--explain

Display the execution plan generated by the database planner for SQL statements like SELECT or UPDATE.

This option is primarily used for debugging purpose.

--until version

Execute upgrade scripts up to version, excluded. Use with caution, as you may not end up with the same data you would get with the official Squore version, as some scripts are rearranged for performance reasons.

This option is primarily used for debugging purpose.

--jdbc-url url

Use alternate database connection, with URL of the form jdbc:subprotocol:subname.

--jdbc-user user

Use alternate database username.

-v, --verbose

Display for each statement the number of selected or modified rows for relevant SQL statements and the execution time in milliseconds, which includes both planning and execution times.

version

Version to upgrade from.