Revision as of 23:09, 20 March 2019

Back to Contents

Back to Migration

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 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.

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:
   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. Run the latest database-update SQL Server script, downloaded above, on the Test database (not Live).
   4. 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.

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.

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\.

Back to Migration

Back to Contents