Pharos Server Migration Tools

Details

Pharos supplies two small command line tools to help in the process of migrating the Pharos database to a new server:

  • DatabaseMigrationTool.exe - this tool copies the Pharos database from its current server to the new one and upgrades it to the current version of Pharos if necessary.

  • NameSyncTool.exe - this tool configures the Pharos database and registry with the hostname details of the new server, and optionally propagates these changes to the other Pharos servers.

When the database migration tool completes, it automatically runs the name synchronization tool to update the Pharos database with the new server's name. The name synchronization tool can also be run by itself if the server's name is changed after the upgrade.

Pre-install

Before running these tools, the new server must be installed as a Pharos Principal Server.

The old server must be running Pharos 5.0 or later. The new server must be running Pharos 8.0 or later. Both servers must be running SQL Server 2000 (or MSDE 2000) or later. When running the tools, you need to be logged on as a user with administrator rights on both servers (typically a domain administrator).

The tools, along with all the deployment files must be copied to the new server and run from there.

Migrating the
Pharos Database

Extract the deployment files provided in the zip file and copy to the new server.

Run the migration tool from the command line on the new server:

DatabaseMigrationTool.exe -OS oldservername [-OU oldsqluserid] [-OP oldsqlpassword] [-NU newsqluserid] [-NP newsqlpassword] [-R] [-?]

Where:

  • oldservername is the host name of the old server
  • oldsqluserid is the SQL Server username on the old server
  • oldsqlpassword is the SQL Server password on the old server
  • newsqluserid is the SQL Server username on the new server
  • newsqlpassword is the SQL Server password on the new server

Note: If no SQL Server authentication details are supplied, Windows authentication is used.

The following options can be specified:

  • -R - attempts to propagate the changes to all Pharos servers.
  • -? - displays Help

A log file for the migration operation is created in the Pharos\Temp directory.

Updating the
Database
Server Name

Run the name sync tool from the command line on the new server:

NameSyncTool.exe [-U userid -P password | -W] [-R] [-?]

The following options can be specified:

  • -U userid -P password - use SQL Server authentication (where userid and password are the logon details for the sa account)
  • -W - use Windows authentication
  • -R - update other Pharos servers remotely (to use this new name for the database server)
  • -? - display Help

The Pharos online Knowledge Base provides more information on suggested procedures for migration using these tools and the tasks these tools will perform. Using the Server Migration Tools.

Need Help?

If further assistance is required, contact your Pharos Authorized Reseller.