Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 796 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

Updating Endpoint database from 4.7 to 5.1

BrentL73

I'm still learning this so bear with me.

I am doing this in a test envirnonment before I move onto our production system.  

Here is my setup basically.

Console sits on test server,THOSAV01

database is on a sqlserver called QHOSQL2k801, no instance but the database is called "sophos47"  and I can get the console to see the database no problem from 4.7

Service account a AD user that is part of the dbadmin group that has access to the database (verified).

I've tried to run the BackupDB.exe but having an issue with setting it up to actually backup and convert the database.

So if I run the upgrade to the console it's not working cause it's looking for the newer database (if I'm correct) and cannot find the database of course

Can someone help me on this.  With having the database on a different SQL server, I'm kind of confused on getting it upgraded to the newest version..

Thanks

:35415


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

    Hi,

    So you have a dstributed installtion. 

    • SEC 4.7 Management server and console on THOSAV01.
    • SOPHOS47 database in a no named SQL instance on QHOSQL2k801.

    You have a user, I'll call it DB which is a domain account, and a member of the local windows group "Sophos DB Admins" on QHOSQL2k801.

    You are now looking to upgrade this to SEC 5.1?

    You don't really need to perform a backup of the SOPHOS47 database, as the databases are always left during the upgrade, no changes are made to the "old" database.

    The upgrade works (in the example of upgrading SEC 4.7 to SEC 5.1) by the following steps:

    1. Creating the new databases of SEC 5.1, i.e. SOPHOS51, SOPHOSPATCH51 and SOPHOSENC51.

    These can be created in the instance by either:

        1. Running the SEC 5.1 installer on the database computer.

        2. Taking the DB directory of SEC 5.1 and manually creating the 3 new databases.

    This is covered in:

    http://www.sophos.com/en-us/support/knowledgebase/116768.aspx

    Once the databases have been created in the SQL instance....

    2. Move to the SEC server (THOSAV01) and run the SEC 5.1 installer.

    As part of the server upgrade, an exe will be run called UpgradeDB.exe.

    This calls a stored procedure in the new SOPHOS51 database which will effectively perform "selects" from the old SOPHOS47 and inserts it into the new SOPHOS51 database.  At the end of the procedure, if all has gone well, the UpgradeStatus in the Upgrade table of the new SOPHOS51 database will be set to 2.

    That's pretty much it.  Once you are happy that the upgrade is ok, you can drop the old SOPHOS47 database, but I would advise taking a backup first just to be safe.

    I hope that helps.

    Regards,

    Jak

    :35419
Reply
  • 0

    Hi,

    So you have a dstributed installtion. 

    • SEC 4.7 Management server and console on THOSAV01.
    • SOPHOS47 database in a no named SQL instance on QHOSQL2k801.

    You have a user, I'll call it DB which is a domain account, and a member of the local windows group "Sophos DB Admins" on QHOSQL2k801.

    You are now looking to upgrade this to SEC 5.1?

    You don't really need to perform a backup of the SOPHOS47 database, as the databases are always left during the upgrade, no changes are made to the "old" database.

    The upgrade works (in the example of upgrading SEC 4.7 to SEC 5.1) by the following steps:

    1. Creating the new databases of SEC 5.1, i.e. SOPHOS51, SOPHOSPATCH51 and SOPHOSENC51.

    These can be created in the instance by either:

        1. Running the SEC 5.1 installer on the database computer.

        2. Taking the DB directory of SEC 5.1 and manually creating the 3 new databases.

    This is covered in:

    http://www.sophos.com/en-us/support/knowledgebase/116768.aspx

    Once the databases have been created in the SQL instance....

    2. Move to the SEC server (THOSAV01) and run the SEC 5.1 installer.

    As part of the server upgrade, an exe will be run called UpgradeDB.exe.

    This calls a stored procedure in the new SOPHOS51 database which will effectively perform "selects" from the old SOPHOS47 and inserts it into the new SOPHOS51 database.  At the end of the procedure, if all has gone well, the UpgradeStatus in the Upgrade table of the new SOPHOS51 database will be set to 2.

    That's pretty much it.  Once you are happy that the upgrade is ok, you can drop the old SOPHOS47 database, but I would advise taking a backup first just to be safe.

    I hope that helps.

    Regards,

    Jak

    :35419
Children
No Data