Layton ServiceDesk - Workflows - Migrate Limited Request Data from One Database to Another
From Layton Support
(Difference between revisions)
(Major additions) |
(Major additions) |
||
Line 10: | Line 10: | ||
=Procedure= | =Procedure= | ||
+ | ==Layton ServiceDesk Steps== | ||
#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. | ||
Line 15: | Line 16: | ||
#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=]]. | ||
+ | |||
+ | ==Management Studio Steps== | ||
+ | #In Management Studio, run this query: | ||
+ | #:<pre> | ||
+ | #::SELECT sys_requestdate | ||
+ | #:: ,sys_eusername | ||
+ | #:: ,sys_problemsummary | ||
+ | #:: ,sys_problemdesc | ||
+ | #:: | ||
+ | #::FROM request | ||
+ | #:: | ||
+ | #::WHERE sys_requestclosedate IS NULL</pre> | ||
+ | #:This will return four columns for any Request that has not been closed. | ||
+ | #two | ||
<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> |
Revision as of 04:54, 28 April 2020
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
- 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.
- 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.
- 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.
- Launch Layton ServiceDesk and configure End User LDAP Import.
- Import End Users by clicking the Import Users button .
Management Studio Steps
- 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.
- two