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

From Layton Support
Revision as of 06:09, 29 April 2020 by Jpainter (Talk | contribs)

Jump to: navigation, search

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

Layton ServiceDesk Steps

  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 and restore it with a different name, giving two databases. The duplicate will be used for testing, then deleted.
  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.

Btn back up.png Back to Contents

Personal tools
Namespaces

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