Layton ServiceDesk - Workflows - Migrate Limited Request Data from One Database to Another
From Layton Support
(Difference between revisions)
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 | + | #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
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
- 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 using Management Studio.
- 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.
- Close SQL Server query without saving.