Upgrade steps:
Backup installation folder and DB.
Uninstall V5
Install V5.1 app
Upgrade DB using scripts in folder "Incremental Upgrade - OnPremV5.1"
Apply new licence for V5.1
Apply web.config file changes e.g ConnectionString
In case of any DB errors during upgrade, use the scripts in folder "Rollback - OnPremV5.1" to rollback DB to V5
Guide Overview
This guide covers the process of upgrading your ResourceXpress system to the latest version to enjoy all the most recent features and enhancements it provides. Whilst this guide is designed to be fully comprehensive, should you have any queries or run into any problems during the upgrade, please contact helpdesk@qedas.com for assistance.
Important Considerations
Before proceeding with any type of upgrade, it is always recommended to create backups in the unlikely event that something goes wrong. Please create a backup of the existing rxpress database in the SQL Management Studio and the application installation directory which will typically be C:\inetpub\wwwroot.
Upgrade Procedure
After the backups are created, extract the software kit provided by our helpdesk onto the ResourceXpress server.
Application
Step 1: Uninstall your current ResourceXpress V5.
Go to Control Panel - Programs and Features and uninstall your current version of ResourceXpress.
Step 2: Install the new version of ResourceXpress.
From the extracted software kit, open the app folder and run setup.exe to install the new version of ResourceXpress.
Be sure to select the ResourceXpress Application Pool that was created during the initial installation when installing this new version.
Database
Step 1: Open SQL Server Management Studio (SSMS) and login to the local or remote SQL server that hosts the application database.
Step 2: In the left pane expand Databases and right-click on rxpress or the name of the database that ResourceXpress is using and select New Query.
The SQL files required for Step 3 can be found in the software in the folder DB -- Incremental Upgrade - OnPremV5.x
Step 3: Copy the entire contents of the file 01 Qed OnPrem DB Table.sql into the query window and execute the script. Alternatively, you can select File - Open - File in SSMS - select the required script - Execute.
Repeat this process for the file 02 Qed OnPrem DB SP.sql.
No changes should be made when executing both scripts.
In the case of any database errors during the upgrade, you can rollback the database to V5 by running the scripts found in DB - Rollback - OnPremV5.1
File Configuration
Licence
Step 1: Navigate to the application installation directory, typically C:\inetpub\wwwroot and locate the ResourceFiles folder.
Step 2: Rename your current licence file mm.lic to mm.lic.OLD.
Step 3: Copy your new licence file to the ResourceFiles folder and be certain that the new file is named mm.lic.
Please submit a request to helpdesk@qedas.com to request your licence
Web.config
Step 1: Navigate to the application installation directory again and locate the Web.config file.
This file should be located in C:\inetpub\wwwroot and not to be confused with the Web.config in the ResourceFiles folder.
Step 2: Open this same Web.config file in the backup that was created in the beginning of this process. Locate the connectionStrings tags at the very bottom of the file and copy & paste into the new Web.config file.
IIS Restart
Once all the steps above have been completed and a new licence has been installed, it is recommended that you restart the Internet Information Services (IIS) Manager.
Step 1: Type IIS in the search bar and open Internet Information Services (IIS) Manager
Step 2: Select the Server Name in the left pane under Connections.
Step 3: In the right pane under Actions - Manage Server click on Refresh.
Verify Upgrade
The upgrade is now complete. You can now log in to ResourceXpress and verify that it is running the new version on the top-right corner of your application.
