Layton ServiceDesk - Installation - Migration - Database Only
From Layton Support
(Difference between revisions)
(Removed section "Version") |
(Expanded steps) |
||
| (8 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <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=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p> | ||
__FORCETOC__ | __FORCETOC__ | ||
=Overview= | =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 '''[[Layton ServiceDesk - Installation - Test Installation|a test installation first]]'''. | |
| − | + | ||
| − | + | ||
| − | + | =Procedure= | |
| − | # | + | ==Backup== |
| − | #Restore the database backup to the new SQL Server | + | #In Management Studio: |
| − | # | + | ##Back up your database. |
| − | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | ##Restore the database backup to the new SQL Server. |
| + | |||
| + | ==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. | ||
| + | #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=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.
