The Sophos Community will be unavailable from 13:00 to 18:00 UTC this Saturday, October 1st for upgrades. Stay tuned to our Twitter account @SophosSupport for updates.
This article explains how to migrate your current installation of Sophos Control Center v4.x from an existing computer to a new computer. If you do not require previous data (policy information and threat history) you may prefer to install a new Control Center on your new server and follow the last two sections of this article to redirect your existing endpoint computers.
To migrate Control Center to a new server, you carry out these steps:
These steps are described in the sections below.
Known to apply to the following Sophos product(s) and version(s) Sophos Control Center 4.0.0Sophos Control Center 4.1Sophos Control Center 4.0.1
On the old server (running the ‘Complete’ installation to be migrated):
cd "C:\Program Files\Sophos\SCC\DB"
cd "C:\Program Files (x86)\Sophos\SCC\DB"
backupdb.bat C:\Windows\Temp\sophos4db.bak .\sophos sophos4
On the new server:
Note: If you failed to uncheck the 'Log off' option you need to log back on, close the Control Center, Open Add/Remove Programs (Start | Run | Type: appwiz.cpl | Press return), locate the 'Sophos Control Center' component and select to uninstall it. Then repeat this section again to re-install the Control Center.
restoredb.bat C:\sophos4db.bak .\sophos sophos4
If the new server's hostname is the same as the old server's hostname you do not need to follow steps one to four below and can immediately skip to step five.
sqlcmd -E -S .\sophos -d sophos4 -i C:\fixsqlmapping.sql
sqlcmd -E -S .\sophos -d sophos4 -i C:\resetWizard.sql
sqlcmd -E -S .\sophos -d sophos4 -i C:\getSUMServerID.sql
sqlcmd -E -S .\sophos -d sophos4 -Q "exec dbo.sddmserverdeletebyid X"
sqlcmd -E -S .\sophos -d sophos4 -i C:\updateShare.sql sqlcmd -E -S .\sophos -d sophos4 -i C:\updateUsername.sql
sqlcmd -E -S .\sophos -d sophos4 -i C:\hideWizard.sql
UpdateManagerHelper -c newServerName "domainname\SophosUpdateMgr" myResetPassword
UpdateManagerHelper -c newServerName "newServerName\SophosUpdateMgr" myResetPassword
Now the new server is set up you must uninstall and the Control Center from the old server using the steps below.
On the old server:
sqlcmd -E -S .\sophos -Q "drop database sophos4"
Remote Management System
If required install endpoint security software on the old server from the new distribution folder available on the new server.
Note: If decommissioning the 'old server' delete this from the computer list view by right-clicking on the Computer name and choosing 'Delete'.
To reconfigure endpoint computers to report to the new server you can either:
Once the endpoint computers have been redirected to the new server you have completed the migration of your Control Center.
Any remote console installations you have on your network should be pointed to the new management server by uninstalling and re-installing the console component.
Every comment submitted here is read (by a human) but we do not reply to specific technical questions. If you need technical support please post a question to our community. Alternatively for licensed products open a support ticket.