Layton ServiceDesk - Workflows - Migrate Limited Request Data from One Database to Another

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Minor text additions)
m (Minor text changes)
Line 13: Line 13:
 
#Create a '''[[Layton ServiceDesk - Installation - Test Installation|Test Installation]]'''. This will be used for testing, but will also become the live installation. This will also give you the latest application version.
 
#Create a '''[[Layton ServiceDesk - Installation - Test Installation|Test Installation]]'''. This will be used for testing, but will also become the live installation. This will also give you the latest application version.
 
#As part of the Test Installation, a new database should be created in the DBTool with the '''[[Layton ServiceDesk - Installation - New Installation - Install New Database|Install New Database]]''' option. This will be the latest database version.
 
#As part of the Test Installation, a new database should be created in the DBTool with the '''[[Layton ServiceDesk - Installation - New Installation - Install New Database|Install New Database]]''' option. This will be the latest database version.
#Before launching Layton ServiceDesk, back up the new database and restore it with a different name, giving two databases. The duplicate will be used for testing, then deleted.
+
#Before launching Layton ServiceDesk, back up the new database using Management Studio.
 
#Launch Layton ServiceDesk and configure '''[[Layton ServiceDesk - Utilities - LDAP Import End User|End User LDAP Import]]'''.
 
#Launch Layton ServiceDesk and configure '''[[Layton ServiceDesk - Utilities - LDAP Import End User|End User LDAP Import]]'''.
 
#Import End Users by clicking the ''Import Users'' button [[File:Lsd ldap import btn 16px.png|link=]].
 
#Import End Users by clicking the ''Import Users'' button [[File:Lsd ldap import btn 16px.png|link=]].

Revision as of 06:13, 29 April 2020

Btn back up.png Back to Contents

Contents

Overview

This workflow can be used to transfer limited Request information from one database to another. It would be used if you wanted to start a brand-new database, abandoning your old one, but wanted to transfer open Requests. This is different to a Migration, which is a full transfer of all information.

References

Procedure

Create Layton ServiceDesk Test Installation

  1. Create a Test Installation. This will be used for testing, but will also become the live installation. This will also give you the latest application version.
  2. As part of the Test Installation, a new database should be created in the DBTool with the Install New Database option. This will be the latest database version.
  3. Before launching Layton ServiceDesk, back up the new database using Management Studio.
  4. Launch Layton ServiceDesk and configure End User LDAP Import.
  5. Import End Users by clicking the Import Users button Lsd ldap import btn 16px.png.

Prepare Old Request Data for Import

  1. In Management Studio, run this query:
    SELECT sys_requestdate
    ,sys_eusername
    ,sys_problemsummary
    ,sys_problemdesc
    FROM request
    WHERE sys_requestclosedate IS NULL
    This will return four columns for any Request that has not been closed.
  2. In the Results pane, click the blank square to the left of the header and above the first row. This will select all cells in the grid.
  3. Right-click and select Copy with Headers.
  4. Open a new Notepad window and paste.
  5. From the File menu, select Save As....
  6. Navigate to the Desktop.
  7. Change the Save as type menu to All Files (*.*).
  8. In the File name field, enter lsd_requests_old.tab. This will save a tab-delimited file.
  9. Close Notepad.
  10. Close SQL Server query without saving.

Import Old Request Data

Next Section

Btn back up.png Back to Contents

Personal tools
Namespaces

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