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

Enterprise Console move and upgrade

keith_co

We are currently running Enterprise Console 4.5.  we also currently run our Enterprise Console on the same server as our SQL Server

we would like to do two things:

1. Upgrade to the newest version of the enterprise conole

2. Move the management pieces off of the SQL Server and put them on their own server, while keeping the SQL database where  it is.

I see a lot of articles on upgrading current setups and such, but nothing to this level.  Any ideas on what steps to take to do this?

thanks

:27483


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

    HI,

    To get some official documentation, the most supported procedure (although odd) might be to move everything to the new server, essentially perform a full migration.  

    You could do this either by migrating SEC 4.5 to the new server or upgrade your current install of SEC to SEC 5.1 and move that.

    You have to migrate the same version of SEC, an upgrade with migrate at the same time is asking for trouble and certainly unsupported.

    SEC 5.1 is more complex than SEC 4,5 but the documentation, installer and tools have improved so I'd probably feel more confident migrating SEC 5,1.  Migration guide is here:

    http://www.sophos.com/en-us/medialibrary/PDFs/migration/sec_51_mgeng.pdf

    The main things to be aware of are:

    1. Going from 32->64 bit machines or 64->32 the registry paths change.

    2. If the locale of the computers differ you might end up with a different SQL collation, this will cause problems.  I would always check the current collation and the new SQL instances collation.  I would probably manually install a SOPHOS instance using SQL Server 2008R2 Express and ensure the collation was the same as your current SQL Server.

    To redirect endpoints:
    http://www.sophos.com/en-us/support/knowledgebase/116737.aspx 

    As this might take a while to settle down, I.e. redirect all the endpoints, make sure they all have their new updating policies, etc.  This could take a week I would think.

    Then I would clear everything off the SQL server, drop Sophos databases.   Then move the database role to the SQL server.

    Maybe re-post if you need help with that.

    How many clients do you have?  Just to check the new server could cope with SQL Express as the database.

    Regards,

    Jak

    :27497
Reply
  • 0

    HI,

    To get some official documentation, the most supported procedure (although odd) might be to move everything to the new server, essentially perform a full migration.  

    You could do this either by migrating SEC 4.5 to the new server or upgrade your current install of SEC to SEC 5.1 and move that.

    You have to migrate the same version of SEC, an upgrade with migrate at the same time is asking for trouble and certainly unsupported.

    SEC 5.1 is more complex than SEC 4,5 but the documentation, installer and tools have improved so I'd probably feel more confident migrating SEC 5,1.  Migration guide is here:

    http://www.sophos.com/en-us/medialibrary/PDFs/migration/sec_51_mgeng.pdf

    The main things to be aware of are:

    1. Going from 32->64 bit machines or 64->32 the registry paths change.

    2. If the locale of the computers differ you might end up with a different SQL collation, this will cause problems.  I would always check the current collation and the new SQL instances collation.  I would probably manually install a SOPHOS instance using SQL Server 2008R2 Express and ensure the collation was the same as your current SQL Server.

    To redirect endpoints:
    http://www.sophos.com/en-us/support/knowledgebase/116737.aspx 

    As this might take a while to settle down, I.e. redirect all the endpoints, make sure they all have their new updating policies, etc.  This could take a week I would think.

    Then I would clear everything off the SQL server, drop Sophos databases.   Then move the database role to the SQL server.

    Maybe re-post if you need help with that.

    How many clients do you have?  Just to check the new server could cope with SQL Express as the database.

    Regards,

    Jak

    :27497
Children
No Data