sqadm upgrade-data(1)

sqadm upgrade-data - Upgrade PC-lint Plus View data

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

This command upgrades PC-lint Plus View data.

The sqadm upgrade-data command shall be executed on a stopped PC-lint Plus View 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 PC-lint Plus View version, and `n' the patch number.

-S, --sql-dir dir

Directory with SQL scripts to upgrade schema.

-D, --data-dir dir

Directory with PC-lint Plus View projects files (<PCLPVIEW_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 PC-lint Plus View 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.