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.
In some cases the Sophos database is not fully upgraded by the management server installer. There are various reasons for the Sophos database not having been upgraded, the most common are:
In any case you may have to run the UpgradeDB.exe command to migrate the data from the previous Sophos database to the latest version. This article explains how to use the UpgradeDB.exe program to upgrade (i.e., transfer data from) a previous Sophos database to the current. This is the same tool called during the upgrade of the management server component.
Known to apply to the following Sophos product(s) and version(s) Enterprise Console 4.7.0Enterprise Console 4.7.1Enterprise Console 5.0.0Enterprise Console 5.1.0Enterprise Console 5.2.0Enterprise Console 5.2.1Enterprise Console 5.2.1 R2Enterprise Console 5.2.2Enterprise Console 5.3.0Enterprise Console 5.3.1Enterprise Console 5.4.0
\Program Files\Sophos\Enterprise Console\
\Program Files (x86)\Sophos\Enterprise Console\
\Program Files\Sophos\Enterprise Manager\
\Program Files (x86)\Sophos\Enterprise Manager\
\Program Files (x86)\Sophos\SCC\
HKEY_LOCAL_MACHINE\SOFTWARE\Sophos\EE\Management Tools\DatabaseConnectionMS HKEY_LOCAL_MACHINE\SOFTWARE\(Wow6432Node)\Sophos\EE\Management Tools\DatabaseConnectionMS
Note: For a list of supported upgrade paths see article 119105.
upgradedb.exe -debug -sourceVersion=521
upgradedb.exe -debug -sourceVersion=52
upgradedb.exe -debug -sourceVersion=51
upgradedb.exe -debug -sourceVersion=50
upgradedb.exe -debug -sourceVersion=47
upgradedb.exe -debug -sourceVersion=45
upgradedb.exe -debug -sourceVersion=2
upgradedb.exe -debug -sourceVersion=45 -udl=sophos.udl
'UpgradeDB.exe' is run as part of the management server installer and not as part of the database installer. It reads the database connection string from the registry of the management server, namely HKEY_LOCAL_MACHINE\SOFTWARE\[Wow6432Node]\Sophos\EE\Management Tools\DatabaseConnectionMS', to locate the SQL instance where the Sophos database resides.
'UpgradeDB.exe' calls the SQL stored procedure 'dbo.FromXto4' or 'dbo.FromX' (depending on version) in the new database to initiate the transfer. Examples of the called commands are as follows:
dbo.FromXto4 4, 0
dbo.FromXto4 45, 0
dbo.FromXto4 47, 0
dbo.FromXto4 50, 0
dbo.FromX 50, 0
dbo.FromX 51, 0
dbo.FromX 51, 0
dbo.FromX 52, 0 dbo.RedirectSynonyms 'SOPHOS521'
dbo,FromX 51, 0
dbo.FromX 52, 0 dbo.RedirectSynonyms 'SOPHOS540'
dbo.FromX 521, 0 dbo.RedirectSynonyms 'SOPHOS540'
If this data is moved successfully from the old database to the new database the 'UpgradeStatus' value in the 'dbo.Upgrade' table of the new database is then set to 2. The upgrade status value is used to tell the Sophos Management Service that the new database has been upgraded as is ready to be used. If the value is not 2 it will fail to start until the upgrade status is correct.
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.