Procedure for migrating only the database to a remote SQL Server

Question

Hello, I need to move the database from the Sophos Enterprise Console where it is currently located to a remote SQL server without moving the other Sophos components. 
 I have seen this procedure: https://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_54_mgeng.pdf?la=en but this is for moving all the components, not only the database. I could take into account only the steps related with moving the database, but I think I would need some additional steps for reconfiguring the console to point out to the new database server... 
 Please, does somebody know if there is a procedure for this (migrate only the database from the Sophos Enterprise Console to a remote SQL server? 
 Thanks in advance! 
 Diego

QC · Accepted Answer

Hello Diego, 
 it's not rocket science. In fact it's pretty simple. 
 Please see How to install/upgrade the Sophos Management Database component on a different (remote) computer and How to move a database from one Remote SQL Server to another . 
 Basically the procedure would be: 
 
 use on of the suggested methods to install the database on the remote server 
 stop the services on the management server 
 backup the databases and restore on remote 
 uninstall the database component on the management server (note: it keeps the instance and databases) 
 re-run the installer on the management server to specify the new database location and change the database user 
 
 Christian