Layton ServiceDesk - Installation - Migration - Database Only

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(New page)
 
(Expanded steps)
 
(9 intermediate revisions by one user not shown)
Line 1: Line 1:
<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>
 +
<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=
We highly recommend that you do not commit to the migrated installation until you are sure that the application is working without issues.
+
This procedure would be used when you need to move only the database to another SQL server.
  
==Version==
+
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]]'''.
Check the '''[[Layton ServiceDesk™ - Procedures - General - How to Find the Version Number|application version]]''' on your live installation. Check the '''[[Main Page|main wiki page]]''' for the latest version.
+
  
If you are not running the latest version on your source installation, please contact Support for the version you are running. You will be provided with a link to the latest full version for use in the below procedures.
+
=Procedure=
 +
==Backup==
 +
#In Management Studio:
 +
##Back up your database.
 +
##Restore the database backup to the new SQL Server.
  
=Migrating Database Only=
+
==Configuration==
==Use Case==
+
#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.
When you need to move just the database to another SQL server.
+
#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''.
==Procedure==
+
<p align="right">[[File:btn back up.png|link=Layton ServiceDesk - Installation - Migration]] [[Layton ServiceDesk - Installation - Migration|<u>Back to ''Migration''</u>]]</p>
#Backup the existing database using Microsoft SQL Server Management Studio (SSMS).
+
<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>
#Restore the database backup to the new SQL Server using SSMS.
+
#Follow '''[[Layton ServiceDesk™ - Installation - Connect to Existing Database|these instructions]]''' to connect to the migrated database.
+
<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

Btn back up.png Back to Contents

Btn back up.png Back to Migration

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

  1. In Management Studio:
    1. Back up your database.
    2. Restore the database backup to the new SQL Server.

[edit] Configuration

  1. 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.
  2. Launch Database Tool (DBTool.exe), choose Connect to an existing database and point it to the new database.
  3. Restart the World Wide Web Publishing Service and LaytonServiceDesk service.

Btn back up.png Back to Migration

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox