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.
Note: These instructions are intended for ServiceDesk 7.1.x. The SD 7.5.x or SD 7.6.x version of this KB can be found at: HOWTO124426.
I. How to Migrate the ServiceDesk Microsoft SQL Server database for ServiceDesk 7.1 GA and 7.1 SP1:
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 database:
Use the above instructions but with the following changes:
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.