Layton ServiceDesk - Installation - Test Installation
m (Clarified text) |
(Added explicit step to disable email by deleting mail server names) |
||
| Line 6: | Line 6: | ||
==Procedure== | ==Procedure== | ||
| − | + | 1. If you will be testing email, create a new email account on your mail server for testing. | |
| − | + | ||
| − | + | 2. Back up your SQL database. | |
| − | + | ||
| − | + | 3. Restore the backup with a different name, on the same SQL server or a different one. | |
| − | + | ||
| − | + | 4. Run this query in Management Studio to delete the email server name in both Incoming and Outgoing sections so that this test installation does not hijack your live system's mail: | |
| − | + | ||
| + | UPDATE setting | ||
| + | |||
| + | SET sys_setting_value = NULL | ||
| + | |||
| + | WHERE sys_setting_name IN | ||
| + | |||
| + | ('inemailpopserver', 'inemailimapserver', 'outemailsmtpserver') | ||
| + | |||
| + | 5. Determine the '''[[Layton ServiceDesk™ - Procedures - General - How to Find the Version Number|application version]]''' installed on your live system. | ||
| + | |||
| + | 6. Contact '''[mailto:[email protected] Support]''' to obtain the version installed on your live system. | ||
| + | |||
| + | 7. Install as per '''[[Layton ServiceDesk™ - Installation - New Installation|New Installation]]'''. When the Database Tool opens, connect to the database copy, not the live one. | ||
| + | |||
| + | 8. If you will be testing email, on first login, change the '''[[Layton ServiceDesk™ - Settings - System Settings - Email Server Settings|Email Server Settings]]''' to your test email server. | ||
| + | |||
| + | 9. If you are testing an upgrade to the latest version, download it from the '''[http://client.laytontechnology.com/ Customer Portal]''' and install it per the instructions in the latest '''[[LSD Current Version|Release Notes]]'''. | ||
<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> | ||
Revision as of 04:54, 11 November 2015
Contents |
Application & Copy of Live Database
Use Case
To test the application with your existing database without affecting the live system. You will be installing the application on a different server to your live installation. You can use a new database, or, if you are testing changes to your live system, you can test on a copy of your live database.
Procedure
1. If you will be testing email, create a new email account on your mail server for testing.
2. Back up your SQL database.
3. Restore the backup with a different name, on the same SQL server or a different one.
4. Run this query in Management Studio to delete the email server name in both Incoming and Outgoing sections so that this test installation does not hijack your live system's mail:
UPDATE setting
SET sys_setting_value = NULL
WHERE sys_setting_name IN
('inemailpopserver', 'inemailimapserver', 'outemailsmtpserver')
5. Determine the application version installed on your live system.
6. Contact Support to obtain the version installed on your live system.
7. Install as per New Installation. When the Database Tool opens, connect to the database copy, not the live one.
8. If you will be testing email, on first login, change the Email Server Settings to your test email server.
9. If you are testing an upgrade to the latest version, download it from the Customer Portal and install it per the instructions in the latest Release Notes.
