Layton ServiceDesk - Workflows - Migrate Limited Request Data from One Database to Another
From Layton Support
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