Layton ServiceDesk - Installation - Migration - Database Only
From Layton Support
(Difference between revisions)
m (Minor text changes) |
(Expanded steps) |
||
| Line 14: | Line 14: | ||
==Configuration== | ==Configuration== | ||
| + | #On the Layton ServiceDesk server, in the Windows Services Console, stop the ''World Wide Web Publishing Service'' and ''LaytonServiceDesk service''. This will take the live installation offline so that no data is altered during the procedure. | ||
#Launch Database Tool (DBTool.exe), choose '''[[Layton ServiceDesk - Installation - Connect to Existing Database|Connect to an existing database]]''' and point it to the new database. | #Launch Database Tool (DBTool.exe), choose '''[[Layton ServiceDesk - Installation - Connect to Existing Database|Connect to an existing database]]''' and point it to the new database. | ||
| + | #Restart the ''World Wide Web Publishing Service'' and ''LaytonServiceDesk service''. | ||
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p> | <p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</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> | <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> | ||
Latest revision as of 20:37, 19 January 2020
Contents |
[edit] Overview
This procedure would be used when you need to move only the database to another SQL server.
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues. Consider doing a test installation first.
[edit] Procedure
[edit] Backup
- In Management Studio:
- Back up your database.
- Restore the database backup to the new SQL Server.
[edit] Configuration
- On the Layton ServiceDesk server, in the Windows Services Console, stop the World Wide Web Publishing Service and LaytonServiceDesk service. This will take the live installation offline so that no data is altered during the procedure.
- Launch Database Tool (DBTool.exe), choose Connect to an existing database and point it to the new database.
- Restart the World Wide Web Publishing Service and LaytonServiceDesk service.
