HOW TO: Move Unitrac to a Different Server

Summary

This document describes how to move an installation of Unitrac from one server to another.

Procedure

The general procedure is as follows:

1. Install Unitrac on the new server.
2. Copy the configuration from the old server to the new server.
3. Set the license.
4. Manually clone the links on the new server.
5. Stop all services on the old server.
6. Copy the database from the older server to the new server.
7. Test the admin website.
8. Start the services on the new server.

1. Install Unitrac

Install the same version of Unitrac on the new server that is on the old server. The Unitrac version may be found by looking at the Version properties of the file RemoveUnitrac.exe which is found in the installation folder. A newer version of Unitrac can be applied to the new server once it is in operation.

Note: install Unitrac with the same password used during installation on the old server. To find that password look at the value of the DSN key in the registry for a Unitrac service (say CtiMsgSvc). The password follows the “PWD=” portion of the string (minus any trailing “;” character).

2. Copy the configuration

The configuration information for both Unitrac and select Windows services must be copied to the new server.

Export the Unitrac registry from the old server and import it into the new server. The following top-level keys are to be copied:

HKEY_LOCAL_MACHINE\SOFTWARE\Corp Ten International\UniTrac Services HKEY_LOCAL_MACHINE\SOFTWARE\CorpTen\UniGate

HKEY_LOCAL_MACHINE\SOFTWARE\UniTrac

HKEY_LOCAL_MACHINE\SOFTWARE\UniTrac Services

Copy the file CtiMsgSvc.vbs from the old server to the new server.

Manually configure the new server’s Default SMTP Virtual Server using the Computer Management applet to reflect the configuration of the old server. Copy the properties and the domains.

3. Set the license

Set the license on the new server (this will require a new key since licenses are locked to a specific machine). Run LicSet.exe which is found in the installation folder (usually c:\Program File\Unitrac).

4. Manually clone links

Create clones on the new server to mirror the clones of the old server. The registry for the cloned links is already in place by virtue of the previous step so only message queues and services need be cloned.

5. Stop services

The old server’s services must be stopped in order to transfer the database with the latest information. Use a script found in the installation folder to stop all Unitrac and related services. From the command line:

> cd \program files\unitrac

> cscript /nologo svcs.vbs /stop /vb

6. Copy the Database

Make a backup of the database on the old server and restore it on the new server. Use SQL server tools to perform the backup and restore. Copy the backup to the new server by any means (CD, network, etc).

These SQL commands can be used to manually create the backup:

USE MASTER

GO

BACKUP LOG Unitrac WITH TRUNCATE_ONLY

GO

BACKUP DATABASE Unitrac TO DISK=’C:\Unitrac.bak’

GO

These SQL commands can be used to manually restore the backup:

USE MASTER

GO

RESTORE DATABASE Unitrac FROM DISK=’C:\Unitrac.bak’

WITH REPLACE, STANDBY=’C:\Unitrac_undo.dat’

GO

RESTORE DATABASE Unitrac WITH RECOVERY

GO

Following restoration the database must be fixed up as follows:

USE Unitrac

GO

EXEC sp_change_users_login ’Auto_fix’, ’UTWeb’

GO

7. Test admin website

Once the database has been moved, run the admin website on the new server to test database connectivity. The login information is the same as for the admin website on the old server.

8. Start the services

Manually configure and start the services on the new server corresponding to automatically started Unitrac services on the old server. Check the Application Event Log for errors.