Revision as of 04:17, 22 June 2017

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.

We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues.

Procedure

Backup

1. Back up the existing application installation directory. The default path is: C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\
2. In Management Studio:
   1. Back up your database.
   2. Restore the backup of your database with a different name, for testing.
   3. Select the test database in the database-selection menu in the upper-left of the main window and run this query to prevent the test installation from hijacking incoming email:

   UPDATE	setting
   
   SET		sys_setting_value = NULL
   
   WHERE	sys_setting_name IN
   
   		('inemailpopserver'
                ,'inemailimapserver'
                ,'inemailcdodropfolder'
                ,'inemailwebdavexchangeurl'
                ,'emailexchangeserver'
                ,'inemailexchangeserver')

Preparation

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. Copy the files from the backup made in the Preparation steps 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

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

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.

Update

1. If you are not running the latest version, update immediately. Refer to the latest release notes for details.

Back to Migration

Back to Contents