Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Upgrade steps:

...

1. Create Backups

...

2. Uninstall/Install the Application

...

3. Run the Database Scripts

...

4. File Configurations

  • 4.1 Apply the new Licence

  • 4.2 wwwroot - Web.config

  • 4.3 ResourceFiles - Web.config

...

5. Restart the IIS

...

Table of Contents

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.

...

Uninstall/Install the 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.

...

Note

Be sure to select the ResourceXpress Application Pool that was created during the initial installation when installing this new version.

Run the Database Scripts

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.

...

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.

Info

Please submit a request to helpdesk@qedas.com to request your licence

wwwroot - Web.config

Step 1: Navigate to the application installation directory again and locate the Web.config file.

Note

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.

...

If any changes were made in the original Web.config file found in the ResourceFiles folder, these will also need to be copied into the new Web.config file located in the new ResourceFiles folder.

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.

...