Layton ServiceDesk - Installation - Migration - Application Only (Direct Update to Latest Version)

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(Major revision)
m (Minor text changes)
Line 44: Line 44:
 
====Installation====
 
====Installation====
 
#Install as per '''[[Layton ServiceDesk - Installation - New Installation|New Installation]]'''.
 
#Install as per '''[[Layton ServiceDesk - Installation - New Installation|New Installation]]'''.
#When the Database Tool opens, choose '''[[Layton ServiceDesk - Installation - Connect to Existing Database|Connect to an existing database]]''' and point it to your Test database.
+
#When the Database Tool opens, choose '''[[Layton ServiceDesk - Installation - Connect to Existing Database|Connect to an existing database]]''' and point it to your Test database, not ''Live''.
  
 
====Restore Application Data====
 
====Restore Application Data====

Revision as of 23:18, 20 March 2019

Btn back up.png Back to Contents

Btn back up.png Back to Migration

Contents

Overview

This procedure would be used when you need to move the application to a new server, but leave the database on the existing SQL server.

Instead of installing the same version as Live on the destination server, the latest version will be installed and the database will be updated with a SQL Server script.

We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues. As there will be a testing period, it is assumed that the Live installation will continue to be used, and backups taken at the beginning of the procedure will be out of sync when it is time to go live. This is accounted for in the procedure.

Procedure

Installation Phase

Download Latest Version

  1. Note the application version on your live installation (Live), for reference.
  2. Check the latest release notes to get the latest version number.
  3. Download the latest full installer.
  4. Download the latest SQL Server database-update script.

Prepare Test Database

  1. In Layton ServiceDesk on the Live server:
    1. Go to Administration > System Settings > Email Server Settings.
    2. Record the contents of all the fields. This is a precautionary step in case they need to be re-entered.
    3. Disable both Auto Import Email Server Settings so that the test installation doesn't hijack incoming mail.
  2. In Management Studio:
    1. Back up your database.
    2. Restore the backup of your database with a different name. This will be the Test database.
  3. In Layton ServiceDesk on the Live server:
    1. Go to Administration > System Settings > Email Server Settings.
    2. Re-enable both Auto Import Email Server Settings to restore processing of incoming mail during the testing period.
  4. In Management Studio:
    1. Run the latest database-update SQL Server script, downloaded above, on the Test database (not Live).
    2. Execute this SQL query to verify that the database has been updated to the latest version number The version number of the database will match that of the application version number:
   SELECT sys_admin_value AS "Database Version Number"
   
   FROM   [admin]
   
   WHERE  sys_admin_id == 'db_compatible_app'

Prepare Server

  1. Check your destination server against the System Requirements.
  2. Run your destination server through the Pre-Installation Procedure.

Installation

  1. Install as per New Installation.
  2. When the Database Tool opens, choose Connect to an existing database and point it to your Test database, not Live.

Restore Application Data

  1. From the backup made in the Preparation steps, copy the files to the same location on the destination server.
    • Application Images\: Custom images added to any forms in Form Design
    • HB_Data\ChangeAttach\: File attachments for Changes
    • HB_Data\Editor_Folder\Image\: User images added to email bodies configured in Email Settings & Bodies
    • HB_Data\EmailBodies\: Email notifications configured in Email Settings & Bodies
    • HB_Data\MailIn\: File attachments from emails in the Incoming email queue
    • HB_Data\ProblemAttach\: File attachments for Problems
    • HB_Data\RequestAttach\: File attachments for Requests
    • HB_Data\LogFiles\: Application log files.

Testing Phase

  1. Test the installation by logging in, creating a request, sending an email, general use. If there is an issue, contact Support for assistance. Do not continue until the issue is resolved.

Final Migration Phase

Update Live Database

Now that testing is complete, the final migration step is to update the Live database to the latest version. Presumably it will have continued to be used in the meantime, and will be out of sync with the Test database.

  1. In Management Studio, run the latest database-update SQL Server script, downloaded above, on the Live database.
  2. Execute this SQL query to verify that the database has been updated to the latest version number:
   SELECT sys_admin_value AS "Database Version Number"
   
   FROM   [admin]
   
   WHERE  sys_admin_id == 'db_compatible_app'

Migrate Application Data

  1. Back up the existing application installation directory by copying it to a location on the destination server. The default path is: C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\


Configuration

  1. Follow this procedure to remap the application support path.
  2. Launch Database Tool (DBTool.exe), choose Connect to an existing database and point it to your live database.
  3. Re-esable both Auto Import Email Server Settings.

Decommission Old Application

  1. On the old server, uninstall Layton ServiceDesk using Programs and Features.
  2. Open Internet Information Services (IIS) Manager.
    1. In Application Pools, delete LaytonServiceDeskAppPool.
    2. In Sites > Default Website, delete the virtual directory LaytonServiceDesk.
  3. Open the Windows Services console.
  4. Check to see if the LaytonServiceDesk service exists. If it does, open a command prompt and run this command to remove it:

    sc delete LaytonServiceDesk

    If the service becomes marked for deletion but hasn't been removed, restart the server and check that the service has been removed.

  5. Delete the folder Layton Technology in C:\Program Files\.

Btn back up.png Back to Migration

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox