How to migrate a ServiceDesk 7.1.x Microsoft SQL database and ServiceDesk 7.1.x application to new servers

Article:HOWTO65815  |  Created: 2012-01-24  |  Updated: 2012-11-09  |  Article URL http://www.symantec.com/docs/HOWTO65815
Article Type
How To

Product(s)


This article describes how to migrate ServiceDesk 7.1.x to a new server OR how to migrate the SD SQL Server database to a new SQL Server.

Note: If moving the SQL database alone follow the instructions as written. If you also want to move the ServiceDesk server add in the instruction steps at the bottom.

Note: These instructions are intended for ServiceDesk 7.1.x, the SD 7.0.x version of this KB can be found at: HOWTO21544.

 

I. How to Migrate the ServiceDesk Microsoft SQL Server database for ServiceDesk 7.1 GA and 7.1 SP1:

  1. On the ServiceDesk server, close Workflow Manager and Process Manager Portal if they are open.
  2. Make a full database backup.
  3. Restore the backup copy to a new SQL server including the database permissions.
    Note: ServiceDesk 7.1 is designed to be used with SQL Server 2005 or 2008 (32 or 64-bit).
  4. On ServiceDesk server go to Start > All Programs > Symantec > Workflow Designer > Workflow Manager, switch to SymQ Configuration tab
  5. Go to SymQ_Local_Defaults > local.orm > Edit, modify Sql Connection String with a proper SQL server name, click OK and then Save to save the changes.
  6. Again under SymQ_Local_Defaults find local.workflowsqlexchange-, click Edit and change SQL server name in the SQL Connection String to the proper one, click OK and then Save to save the changes.
  7. While still in SymQ Configuration tab go to Workflow_Core, locate local.workflowsqlexchange-, click Edit and change SQL server name in the SQL Connection String to the proper one again, click OK and then Save to save the changes.
  8. Go to <install drive>:\Program Files\Symantec\Workflow\ProcessManager, open web.config file in Notepad
  9. Replace the old SQL server name with a new SQL server name in ConnectionString line, save the file.
  10. Run iisreset command
  11. Go to Services and restart Symantec Workflow Server.

 

II. How to Migrate the ServiceDesk Microsoft SQL Server database for ServiceDesk 7.1 SP2:

In ServiceDesk 7.1 SP2 ConnectionString is encrypted within web.config and to be able to update that it is required to have Workflow 7.1 SP2 pointfix rollup installed.
Follow steps 1 – 7 as above.
8. Open command window and run the command
<SD install Drive>:\Program Files\Symantec\Workflow\Tools\lbutil.exe  –updatepmconnection –connectionstring <connectionstring> -webconfig <web.config path>
(Connection string can be copied from SymQ Configuration > SymQ_Local_Defaults > local.workflowsqlexchange- settings.)
9. Run iisreset command
10. Go to Services and restart Symantec Workflow Server.

 

III. How to Migrate the ServiceDesk server instead of the SD SQL server databse:

Use the above instructions but with the following changes:

  1. On the ServiceDesk server, close Workflow Manager and Process Manager Portal if they are open.
  2. In Windows, click on the Start button > Administrative Tools > Services.
  3. Locate the Symantec Workflow Server service, right click on it and click on Stop.
  4. Click on the Windows Start button > Run, enter iisreset /stop command, click the OK button.
  5. Backup any customized Workflow projects. Project folders are stored in the <ServiceDesk_installation_drive>:\Program Files\Symantec\Workflow\WorkflowProjects folder.
    Note: If customized projects are not backed up, these may be overwritten by the reinstall of ServiceDesk, performed later in these instructions. If so, there is no method to recover these unless a backup has previously been performed on them. For more information on how to backup and restore project customizations, please refer to the following article: HOWTO36202
  6. Reinstall ServiceDesk by following instructions from HOWTO49691. During the reinstall, choose New Install and then choose the existing database server. Do not select to create a new database, unless the old database is not wanted any longer.
  7. Restore any customized Workflow projects from backup.
  8. In Windows, click on the Start button > Administrative Tools > Services.
  9. Locate the Symantec Workflow Server service, right click on it and click on Start.
  10. Run iisreset /start command.

Warning: If the old database is used do not change the name of the ServiceDesk server. If the name of the ServiceDesk server is changed and the original database is kept, this will result in issues. For example, URLs in e-mail messages will point to the old server name. Other references to the old server name will also no longer be valid. This will then require manual changes in various areas, such as Application Properties.

 




Article URL http://www.symantec.com/docs/HOWTO65815


Terms of use for this information are found in Legal Notices