U
 Get in Touch
U

Last updated Aug 27, 2018

How To: Move a HighGear Application To a New Server

Moving a HighGear database to a new server is a complicated process, and it must be performed precisely as described in this document. There is no danger of data loss or corruption on the old server, but the new server will not operate correctly unless the entire process is performed correctly.

Also, the same version of HighGear BPM software must be installed on both the old server and the new server. Otherwise, the new server will not be able to read the database accurately. To make sure that the process works correctly, we recommend that you upgrade both servers to the latest version of HighGear before beginning the transfer process.

Upgrade the old server to the latest version of HighGear

  1. Contact Support to get the latest HighGear installer
  2. Log in to the old HighGear server and run the setup program
  3. It will disconnect all your HighGear users, make a pre-upgrade backup of the database, and perform the upgrade

Backup the old server’s HighGear database

  1. Open SQL Management Studio on the old server
  2. Open the HighGear database
  3. Backup the database

If your old server has the Business Intelligence Module, backup the old server’s HighGear_Reporting database

  1. Open SQL Management Studio on the old server
  2. Open the HighGear_Reporting database
  3. Backup the database

Install the latest version of HighGear on the new server

  1. Log in to the new HighGear server and run the same setup program that you ran on the old server
  2. It will install HighGear on your new server
  3. When the Configuration tool appears, enter the same values that you used on your old server, but do not enter a license key
  4. If your old server had the Business Intelligence Module, select “Yes” when the installer asks if you want to install the BI Module

Load the database backup onto the new server

  1. Open SQL Management Studio on the new server
  2. Open the HighGear database
  3. Restore the backup file into the HighGear database, with the Overwrite option checked
  4. Open the Security folder in the HighGear database
  5. Open the Users folder
  6. Delete all of the users that are there
  7. Go to the server’s Security folder, and open the Logins folder
  8. You will see three HighGear users: HighGear, HighGear_Admin, and HighGear_Reporting
  9. Right-click on the HighGear user and click Properties
  10. Go to the User Mapping page
  11. Check the “Map” box for the HighGear database
  12. In the Role Membership section, check db_datareader and db_datawriter
  13. Click OK
  14. Do the same thing for HighGear_Admin, but check db_datareader, db_datawriter, and db_owner
  15. Do the same thing for HighGear_Reporting, but only check db_datareader
  16. Now, go back to the HighGear database and open the Programmability folder
  17. Open the Functions folder, and go to the Scalar-valued Functions folder
  18. That list will contain several functions. For each one, do the following:
    1. Right-click on the function and click Properties
    2. Go to the Permissions page
    3. Click the Search button, click Browse, and select HighGear, HighGear_Admin, and HighGear_Reporting
    4. Click OK twice to get back to the Permissions page
    5. Select each user in turn, and check the Grant box for the Execute permission
    6. Click Ok

If your old server had the Business Intelligence Module, do the following:

  1. Open the HighGear_Reporting database
  2. Restore the backup file into the HighGear_Reporting database, with the Overwrite option checked
  3. Open the Security folder in the HighGear_Reporting database
  4. Open the Users folder
  5. Delete all of the users that are there
  6. Go to the server’s Security folder, and open the Logins folder
  7. You will see two HighGear users: HighGear, and HighGear_Reporting
  8. Right-click on the HighGear user and click Properties
  9. Go to the User Mapping page
  10. Check the “Map” box for the HighGear_Reporting database
  11. In the Role Membership section, check db_datareader , db_datawriter, and db_owner
  12. Click Ok
  13. Right-click on the HighGear_Reporting user and click Properties
  14. Go to the User Mapping page
  15. Check the “Map” box for the HighGear_Reporting database
  16. In the Role Membership section, check db_datareader and db_datawriter
  17. Click Ok

Load the license on the new server

  1. Call Swift Software’s support team and ask them to transfer your existing license to the new server
  2. Log in to HighGear on the new server; it will take you to the Licensing page
  3. Click the Update License button

If you are unsure about any stage of this process, please contact support to discuss your questions.

Schedule Consultation