Layton ServiceDesk - Installation - Upgrade Database

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Expansion of text)
(New section)
Line 33: Line 33:
 
</ol>
 
</ol>
  
 +
<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>
 
====Upgrade====
 
====Upgrade====
 +
Launch the Database Tool and click the ''Upgrade Database'' button:<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_01.png]]<br/><br/>
 +
 +
Click the ''Select'' button next to the Server field. In the Select SQL Server dialog, select a SQL Server from the list, then click the ''Select'' button. This will populate the Server field in the main window.<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_02.png]]<br/><br/>
 +
 +
Check the ''Use Trusted Connection'' checkbox. This will authenticate as the logged-in user. This user will need to have administrative permissions on the SQL Server to continue. Select your HelpBox database in the ''Database Name'' menu. Most likely this will be called ''HelpBox'', which is the default database name:<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_03.png]]<br/><br/>
 +
 +
Click the ''Test'' button to test the connection to the SQL Server with the provided details. If successful, a dialog will confirm:<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_04.png]]<br/><br/>
 +
 +
Click the ''Upgrade Database'' button:<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_05.png]]<br/><br/>
 +
 +
You will be warned that you should have a back-up of your database before proceeding. Confirm that you want to continue at this time:<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_06.png]]<br/><br/>
 +
 +
Click the ''OK'' button to dismiss the dialog and return to the installer. Click the ''Close'' button to exit.<br/><br/>
 +
 +
[[File:Lsd_upgrade_db_07.png]]<br/><br/>
  
 
==Tips on Migration==
 
==Tips on Migration==

Revision as of 23:37, 20 October 2010

Btn back up.png Back to Contents

Contents

Notes

The Upgrade Database option is used to migrate existing HelpBox v5.0.5 databases to Layton ServiceDesk. It may also be used to upgrade Layton ServiceDesk databases to newer versions if required in the future. If you are starting a fresh installation of Layton ServiceDesk and do not wish to keep any existing data from your current HelpBox installation you can skip the following steps and start using Layton ServiceDesk right away, once you have it installed.

Note: You must be running HelpBox v5.0.5 or later to be able to migrate the database to Layton ServiceDesk. If you are running an earlier version, please upgrade before proceeding. Please contact your local Layton Technology office if you have any questions.

Layton ServiceDesk is not an upgrade for HelpBox but a completely new product, as such there is a limitation on what will be retained from HelpBox:

Database

All the data in your existing HelpBox database will be retained when you migrate to Layton ServiceDesk, including all request classes.

Form Designs

When migrating from HelpBox to Layton ServiceDesk, all your current form designs such as Analyst and End User Request forms, Login Screen design layouts and the all the List Views, will be lost. These will be replaced by our default Layton ServiceDesk forms. See the Tips section below for some useful ideas for reproducing your existing HelpBox form designs.

Reports

Layton ServiceDesk includes over 100 canned reports. All your existing reports in HelpBox will be replaced with the new reports. Any custom reports you may have created will be lost.

ActiveDirectory, Email and AuditWizard Databridge Settings

Layton ServiceDesk uses a different method of connecting to ActiveDirectory, Exchange and AuditWizard (if applicable). Once you have migrated to Layton ServiceDesk you will need to re-enter any Active Directory, Exchange and AuditWizard database details.

Your existing email bodies in HelpBox can be copied to Layton ServiceDesk if required. Copy the email body XML folder from the HelpBox programs folder to the Layton ServiceDesk email folder. You may need to reformat the email bodies slightly when they are added as the emails in HelpBox are in plain text whereas in Layton ServiceDesk you have the option of using the WYSIWYG editor.

Important: Always make a backup of your existing HelpBox database before you migrate.

Installation

Steps

Preparation

  1. Install Layton ServiceDesk as per New Installation.
  2. Copy the contents of C:\LaytonHelpBoxSQL\RequestAttach\ to C:\Program Files\Layton Technology\Layton ServiceDesk\HBData\RequestAttach\.
  3. Copy any email bodies that you modified and want to keep (stored as XML files) from C:\LaytonHelpBoxSQL\EmailBodies\ to C:\Program Files\Layton Technology\Layton ServiceDesk\HBData\EmailBodies\.

Btn back up.png Back to Contents

Upgrade

Launch the Database Tool and click the Upgrade Database button:

Lsd upgrade db 01.png

Click the Select button next to the Server field. In the Select SQL Server dialog, select a SQL Server from the list, then click the Select button. This will populate the Server field in the main window.

Lsd upgrade db 02.png

Check the Use Trusted Connection checkbox. This will authenticate as the logged-in user. This user will need to have administrative permissions on the SQL Server to continue. Select your HelpBox database in the Database Name menu. Most likely this will be called HelpBox, which is the default database name:

Lsd upgrade db 03.png

Click the Test button to test the connection to the SQL Server with the provided details. If successful, a dialog will confirm:

Lsd upgrade db 04.png

Click the Upgrade Database button:

Lsd upgrade db 05.png

You will be warned that you should have a back-up of your database before proceeding. Confirm that you want to continue at this time:

Lsd upgrade db 06.png

Click the OK button to dismiss the dialog and return to the installer. Click the Close button to exit.

Lsd upgrade db 07.png

Tips on Migration

If you wish to use the default form designs that are installed with Layton ServiceDesk and do not require any existing designs to be replicated from your existing HelpBox installation you can skip the following steps.

If you have customized your HelpBox forms, login screens etc. and would like to keep them the same in Layton ServiceDesk, we recommend you follow these steps:

  1. Install a clean installation of Layton ServiceDesk
  2. Configure/customize your new installation of Layton ServiceDesk to match your existing forms, login screens as they appear in your current live HelpBox installation. Once you are happy with how your new installation of Layton ServiceDesk looks, you are now ready to migrate your existing HelpBox database.
  3. Back up your HelpBoxBox application folder and database.
  4. Migrate your HelpBox database to Layton ServiceDesk.
  5. Use the Copy Form Design option in the Database Tool to copy your newly created design layouts from the first installation of Layton ServiceDesk you installed (where you customized the forms etc) to your newly upgraded HelpBox installation.

By using the the Copy Form Design steps, you can spend as much time as you require to get your new installation of Layton ServiceDesk just right before you need to upgrade. You will also have virtually no downtime whatsoever when you are ready to go live.

Btn back up.png Back to Contents

Personal tools
Namespaces

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