SEC 5.2 to 5.5 upgrade to new server

Question

Hello, 
 We have a client who wishes to upgrade from SEC 5.2 to 5.5. 
 They have a remote SQL database server but want to move SEC from Server 2012 to Server 2016. 
 The server to server migration document only talks about migrating where database is local. 
 What is the process to move to SEC on Server 2016 where a remote SQL database is used? I am assuming we need to upgrade SEC components to 5.5 prior to migrating to another server. 
 Thanks. 
 Andrew

QC · Answer

Hello Andrew, 
 when using a remote database the database component must be upgraded first . After that the management server and console components can either be upgraded on the server they reside or simply installed on a new server ( setup.exe will ask for the database location). 
 Christian

Haridoss Sreenivasan · Answer

Hi Andrew, 
 It is better to upgrade to 5.5.0. 
 Assuming that you will have the backup of the database, delete all the Sophos Databases on the remote SQL and follow the migration guide . As per step 8, you will be restoring the Database which should get things working again. Let me know if this helps resolve the issue.

Haridoss Sreenivasan · Answer

Hi Andrew, 
 So the process goes as follows: 
 - First upgrade to 5.5.0 
 - Then, migrate to the new server 
 - During the process of migration, you will be asked to select the location of the database server 
 - Now point it to the remote database server 
 Please do take a backup of the database to be on the safer side. Let me know if this helps resolve your query.