Layton ServiceDesk - Installation - Migration - Application and Database

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Minor text changes)
(Major revision)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
+
<p align="right">[[File:btn back up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p>
 
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p>
 
__FORCETOC__
 
__FORCETOC__
 
=Overview=
 
=Overview=
 +
This procedure would be used when you need to move both application and database to another or other servers.
 +
 
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues.
 
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues.
  
==Version==
+
=Procedure=
Check the '''[[Layton ServiceDesk - Procedures - General - How to Find the Version Number|application version]]''' on your live installation. Check '''[[LSD Current Version|here]]''' for the latest version.
+
==Check Version==
 +
#Check the '''[[Layton ServiceDesk - Procedures - General - How to Find the Version Number|application version]]''' on your live installation (''Live'').
 +
#Check '''[[LSD Current Version|here]]''' for the latest version.
 +
#If you are not running the latest version on your source installation, please '''[mailto:[email protected] contact Support]''' for the version you are running. You will be provided with a link to a full version for use in the below procedures. Note that this may be earlier than Live, because not every upgrade release had an accompanying Full version. In this case, you will be installing the next-lowest Full version, followed by the same version as Live.
  
If you are not running the latest version on your source installation, please contact Support for the version you are running. You will be provided with a link to the latest full version for use in the below procedures.
+
==Backup==
 +
#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\''
 +
#In Layton ServiceDesk:
 +
##Go to '''[[Layton ServiceDesk - Settings - System Settings - Email Server Settings|Administration > System Settings > Email Server Settings]]'''.
 +
##Record the contents of all the fields. This is a precautionary step in case they need to be re-entered.
 +
##Disable both '''[[Layton ServiceDesk - Settings - System Settings - Email Server Settings#Auto Import Settings|Auto Import Email Server Settings]]''' so that the test installation doesn't hijack incoming mail.
 +
#In Management Studio:
 +
##Back up your database.
 +
##Restore the database to the new SQL Server with the same name.
  
=Migrating Application and Database=
+
==Preparation==
==Use Case==
+
When you need to move both application and database to another or other servers.
+
 
+
==Procedure==
+
#Backup the existing application installation directory. The default path is: ''C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\''.
+
#Backup the existing database using Microsoft SQL Server Management Studio (SSMS).
+
#Restore the database backup to the new SQL Server using SSMS.
+
 
#Check your destination server against the '''[[Layton ServiceDesk - System Requirements|System Requirements]]'''.
 
#Check your destination server against the '''[[Layton ServiceDesk - System Requirements|System Requirements]]'''.
 
#Run your destination server through the '''[[Layton ServiceDesk - Pre-Installation Procedure|Pre-Installation Procedure]]'''.
 
#Run your destination server through the '''[[Layton ServiceDesk - Pre-Installation Procedure|Pre-Installation Procedure]]'''.
#Install the application on the new server 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 ServiceDesk database restored on the new SQL Server in Step 3.
+
==Installation==
#Copy the needed files from the backup made in Step 1 to your new application installation directory. Some common items that may need to be migrated are:
+
#Install as per '''[[Layton ServiceDesk - Installation - New Installation|New Installation]]'''.
#*''Application_Images\'' - If custom images were added to any forms in '''[[Layton ServiceDesk - Configuring the System - Form Design|Form Design]]'''
+
#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.
#*''HB_Data\ChangeAttach\'' - File attachments for '''[[Layton ServiceDesk - Logging a New Change#Change Logging|Changes]]'''
+
 
#*''HB_Data\Editor_Folder\Image\'' - User images added to email bodies configured in '''[[Layton ServiceDesk - Settings - Libraries - Email Settings & Bodies#Adding Images to Email Bodies|Email Settings & Bodies]]'''
+
==Upgrade to Same Version as Live==
#*''HB_Data\EmailBodies\'' - Email notifications configured in '''[[Layton ServiceDesk - Settings - Libraries - Email Settings %26 Bodies|Email Settings & Bodies]]'''
+
#If the full version you installed was earlier than Live, immediately upgrade to the same version as Live, using the Upgrade installer provided by Support.
#*''HB_Data\MailIn\'' - File attachments for emails in the '''[[Layton ServiceDesk - Logging A New Request#Converting an Incoming Email into a Request|Incoming email queue]]'''
+
 
#*''HB_Data\ProblemAttach\'' - File attachments for '''[[Layton ServiceDesk - Logging a New Problem#Problem Logging|Problems]]'''
+
==Restore Application Data==
#*''HB_Data\RequestAttach\'' - File attachments for '''[[Layton ServiceDesk - Logging A New Request#Overview|Requests]]'''
+
#From the backup made in the '''[[#Preparation|Preparation]]''' steps, copy the files to the same location on the destination server.
#*''HB_Data\LogFiles\'' - Application log files
+
#*''Application Images\'': Custom images added to any forms in '''[[Layton ServiceDesk - Configuring the System - Form Design|Form Design]]'''
 +
#*''HB_Data\ChangeAttach\'': File attachments for '''[[Layton ServiceDesk - Logging a New Change#Change Logging|Changes]]'''
 +
#*''HB_Data\Editor_Folder\Image\'': User images added to email bodies configured in '''[[Layton ServiceDesk - Settings - Libraries - Email Settings & Bodies#Adding Images to Email Bodies|Email Settings & Bodies]]'''
 +
#*''HB_Data\EmailBodies\'': Email notifications configured in '''[[Layton ServiceDesk - Settings - Libraries - Email Settings %26 Bodies|Email Settings & Bodies]]'''
 +
#*''HB_Data\MailIn\'': File attachments from emails in the '''[[Layton ServiceDesk - Logging A New Request#Converting an Incoming Email into a Request|Incoming email queue]]'''
 +
#*''HB_Data\ProblemAttach\'': File attachments for '''[[Layton ServiceDesk - Logging a New Problem#Problem Logging|Problems]]'''
 +
#*''HB_Data\RequestAttach\'': File attachments for '''[[Layton ServiceDesk - Logging A New Request#Overview|Requests]]'''
 +
#*''HB_Data\LogFiles\'': Application log files.
 +
 
 +
==Testing==
 +
#Test the installation by logging in, creating a request, sending an email, general use. If there is an issue, '''[mailto:[email protected] contact Support]''' for assistance. Do not continue until the issue is resolved.
 +
 
 +
==Configuration==
 
#Follow '''[[Layton ServiceDesk - General Troubleshooting - PDF Report Not Attached to Scheduled Report Email|this procedure]]''' to remap the application support path.
 
#Follow '''[[Layton ServiceDesk - General Troubleshooting - PDF Report Not Attached to Scheduled Report Email|this procedure]]''' to remap the application support path.
#If you are not running the latest version, update immediately. Refer to the '''[[LSD Current Version|latest release notes for details]]'''.
+
#Launch Database Tool (DBTool.exe), choose '''[[Layton ServiceDesk - Installation - Connect to Existing Database|Connect to an existing database]]''' and point it to your live database.
 +
#In Layton ServiceDesk:
 +
##Go to '''[[Layton ServiceDesk - Settings - System Settings - Email Server Settings|Administration > System Settings > Email Server Settings]]'''.
 +
##Using the values that you recorded in the '''[[#Backup|Backup]]''' section, populate the empty fields and test both incoming and outgoing email.
 +
 
 +
==Decommission Old Application==
 +
#On the old server, uninstall Layton ServiceDesk using Programs and Features.
 +
#Open Internet Information Services (IIS) Manager.
 +
##In ''Application Pools'', delete ''LaytonServiceDeskAppPool''.
 +
##In ''Sites > Default Website'', delete the virtual directory ''LaytonServiceDesk''.
 +
#Open the Windows Services console.
 +
#Check to see if the ''LaytonServiceDesk'' service exists. If it does, open a command prompt and run this command to remove it:<br /><br /><p><code>sc delete LaytonServiceDesk</code><br /><br />If the service becomes ''marked for deletion'' but hasn't been removed, restart the server and check that the service has been removed.</p>
 +
#Delete the folder ''Layton Technology'' in C:\Program Files\.
 +
#On the new SQL Server, ensure that the database has been backed up by standard backup procedure.
 +
#When that is confirmed, on the old SQL Server, delete the old database.
 +
 
 +
==Upgrade to Latest Version==
 +
#If you are not running the latest version, update as soon as possible. Refer to the '''[[LSD Current Version|latest release notes for details]]'''.
 
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p>
 
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p>
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
+
<p align="right">[[File:btn back up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>

Latest revision as of 23:11, 26 June 2017

Btn back up.png Back to Contents

Btn back up.png Back to Migration

Contents

[edit] Overview

This procedure would be used when you need to move both application and database to another or other servers.

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

[edit] Procedure

[edit] Check Version

  1. Check the application version on your live installation (Live).
  2. Check here for the latest version.
  3. If you are not running the latest version on your source installation, please contact Support for the version you are running. You will be provided with a link to a full version for use in the below procedures. Note that this may be earlier than Live, because not every upgrade release had an accompanying Full version. In this case, you will be installing the next-lowest Full version, followed by the same version as Live.

[edit] Backup

  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\
  2. 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.
  3. In Management Studio:
    1. Back up your database.
    2. Restore the database to the new SQL Server with the same name.

[edit] Preparation

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

[edit] 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.

[edit] Upgrade to Same Version as Live

  1. If the full version you installed was earlier than Live, immediately upgrade to the same version as Live, using the Upgrade installer provided by Support.

[edit] 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.

[edit] 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. Do not continue until the issue is resolved.

[edit] 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. In Layton ServiceDesk:
    1. Go to Administration > System Settings > Email Server Settings.
    2. Using the values that you recorded in the Backup section, populate the empty fields and test both incoming and outgoing email.

[edit] 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\.
  6. On the new SQL Server, ensure that the database has been backed up by standard backup procedure.
  7. When that is confirmed, on the old SQL Server, delete the old database.

[edit] Upgrade to Latest Version

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

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