Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » QAnywhere » QAnywhere API Reference » QAnywhere Agent utilities reference » qaagent utility


-sur option

Upgrades a client message store to the current version.

qaagent -sur -c "connection-string" ...

Specify the database to upgrade in the connection string. The -sur option automatically unloads the message store, reloads it, and upgrades it.

The unload/reload is necessary to upgrade from a version 9 message store to a version 10 message store. The unload/reload can be done manually along with the -su option. For example, if you need to perform custom actions after the reload and before the upgrade, use the -su option.

This operation exits when the upgrade is complete.

This operation cannot be undone.

See also

The following example unloads and reloads a version 9.0.2 SQL Anywhere database called qanywhere.db, making it useful with QAnywhere version 11.

qaagent -q -sur -c "UID=dba;PWD=sql;DBF=qanywhere.db"