Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 2083 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade from SEC 4.7 to SEC 50

BudgetHelp

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>;

:19561


This thread was automatically locked due to age.
Parents
  • 0

    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
Reply
  • 0

    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
Children
No Data