How can we help?
Table of Contents
< All Topics
Print

RPM Upgrade for SQL

Updated

This article only applies to RPM Onsite licenses using a SQL Server database. To view the type of license you have, open the System Info screen under the RPM Help menu.

See all the changes in this upgrade

Upgrading to Version 6.0.6

The RPM Client has been upgraded from Access 2013 to Access 365. RPM Client workstations must be upgraded if either of the two cases below apply. Follow the RPM Client Installation instructions if needed.

  1. You are currently running RPM version 5.x.x.
  2. You are currently running RPM version 6.x.x and the workstation displays Access Version 15 on the System Info screen.

RPM Server Installation

The upgrade needs to be installed to the RPM Server folder. RPM itself can only be run on a computer with the RPM Client installed (which is usually not the server). The SQL Database Upgrade will need to be completed from a computer that has SQL Server Management Studio installed with access to the SQL Server database(s).

Before starting, open the System Info screen under the RPM Help menu. Use the Report button and print a copy of your current RPM system information. This will show the version of RPM you are currently running and the network location.

Open the Reports screen in RPM and select the Miscellaneous section. Select the Company List report and click Report to get a list of the SQL Server database(s) used in RPM. (This report is only available in version 6.0.2 or later. If you are running an older version of RPM, open the SQLConnect application in the RPM Server folder to see the database(s).)

Make sure all users have closed RPM. Make sure you have a backup of your RPM Server folder (the Network Path from the System Info screen).

SQL Database Upgrade

  1. Download and unzip the required SQL Script based on the version of RPM you are currently running (as shown on the System Info report).
  2. Open SQL Server Management Studio for the SQL Server shown on the Company List report.
  3. Backup each RPM SQL Server database before continuing.
  4. Select Open, File from the File menu. Open the SQL upgrade script downloaded in step 1. The script to open should be RPMSQLUpgradeScript_VersionXXXtoYYY.sql where XXX is your current RPM version and YYY is the upgraded version.
  5. Follow the instructions at the top of the script to change the database name RPMDB to your actual SQL database name.
  6. Click Execute to run the SQL script.

Repeat steps 5 and 6 for each RPM SQL database.

RPM Server Upgrade

Download the upgrade. After downloading, right-click on the file and select “Run as administrator”. The welcome screen will be displayed.

Click Next to continue.

Accept the license agreement and click Next. The destination folder will be displayed.

The Destination Folder should default to your current RPM Network Path if RPM has been installed from this computer previously. If the path is not correct, use the Browse button to select your current RPM Server folder. The Destination Folder should match the Network Path location shown on your System Info report.

Click Next to continue.

Click Install to begin the RPM Server installation.

Click Finish when the server installation is complete.

Open RPM on one workstation to complete the upgrade.

Verify the new version has been correctly installed by opening the System Info screen in RPM. The version displayed should be 6.0.6. After this, other users can get back into RPM.

Upgrade the remaining RPM Client workstations, if needed, following the instructions below.

RPM Client Installation

The RPM Client only needs to be upgraded on workstations that are not currently using Access Version 16.

  • If you are upgrading from RPM version 5.x.x, all RPM Client workstations must be upgraded.
  • If you are upgrading from 6.0.0 – 6.0.5, only workstations that display Access Version 15 on the System Info screen must be upgraded.

To upgrade the RPM Client, run the RPMClientSetup application in the Client Install folder under the RPM Server folder. The RPM Server folder location is the Network Path from your System Info report. For a single computer installation, this will usually be C:\RPM Server\Client Install/RPMClientSetup.exe.

For a network installation, this will be a server location (for example, \\server\RPM Server\Client Install\RPMClientSetup.exe).

Right-click on the RPMClientSetup application and select “Run as administrator” to run the installation. The prerequisite Access 365 runtime will be installed first.

Click Install to install the 64-bit Access runtime.

If 32-bit Office is currently installed on the workstation, the 64-bit version cannot be installed. Click Install 32-bit instead.

Click Close when complete. The RPM Client Setup screen will then be displayed.

Click Next and follow the remaining prompts to complete installing the RPM Client. Click Finish when the installation is complete. After restarting the workstation, RPM can be opened