Database Upgrade


This topic applies to installations with data sources that are using a database as their data store.

Some Remote Desktop Manager releases must alter the database structure. These are performed automatically for you but it is best practice to perform a backup of your data source beforehand. Additionally, If you are in a team environment you must be the sole user connected to the database during the upgrade.

The user performing the update must have administrative privileges on the underlying database. ( SYSDBA or DB_OWNER) .

Perform a database backup and ensure that you can quickly perform a restore if required.

If your organization allows for a read/write offline cache, ensure that all of your users have merged their offline edits.


Follow these steps for a successful version update:

  1. Ensure you are the sole user of the database during the upgrade process. If you environment allows for offline use, have your team switch to the offline mode; or have them switch to another data source.

  2. Back up your database using the database tools.

  3. Install the desired version of Remote Desktop Manager , using the Portable (USB) deployment model may be desirable if you are doing this on your personal workstation.

  4. Open Remote Desktop Manager while logged on as a user with administrative rights. You must also be SYSDBA or DB_OWNER .

  5. You may be prompted with an upgrade message when your data source is accessed. If so accept the upgrade.
    Using File – Data sources , locate your data source to upgrade and open its property window. Switch to the Upgrade tab, then click on Update Database

  6. Wait for a confirmation dialog.

  7. Close the dialog.

  8. Ensure your Remote Desktop Manager application is currently using that data source.

  9. Press CTRL+F5 to force a full refresh.

  10. Validate the content and perform a check of the technologies that are critical in your environment.

  11. Update the client software on all workstations.