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 .
Prepare Old Request Data for Import
- 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.
- 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.
- Right-click and select Copy with Headers.
- Open a new Notepad window and paste.
- From the File menu, select Save As....
- Navigate to the Desktop.
- Change the Save as type menu to All Files (*.*).
- In the File name field, enter lsd_requests_old.tab. This will save a tab-delimited file.
- Close Notepad.