Upgrade from SEC 4.7 to SEC 50

Question

Hi - I need to know how to upgrade SEC 4.7 to 50 but more so on the database side

We have the following set up:

Windows_ServerA running SEC4.7 and Update Mgr

Windows_ServerB running SQL 2008 Server with SOPHOS47 database

I can upgrade the SEC console no problem, but need advise on how to upgrade the SOPHOS47 DB to SOPHOS50 ?

On the SEC server to talk to the remote database, we modified this key:

Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=SOPHOS47;Data Source=<serverB>;

This thread was automatically locked due to age.

jak · Accepted Answer

HI,

You need to run the installer on the DB machine first. All this will do is create 2 "empty" databases in the SQL instance:

SOPHOS50 
 SOPHOSPATCH

This stage will leave the existing SOPHOS47 database and SEC 4.7 will continue to work.

You then run the installer on the mamagement server, this will remove SEC 4.7 and install SEC 5.0. As part of this install it will run a command line tool called UpdgradeDB.exe this will connect to the database machine and run a stored procedure that will copy the data from SOPHOS47 to the new SOPHOS50.

You're then done.

Hope this helps.

Regards, 
 Jak :19587