I have recently been asked to consolidate our current three sophos server into one server (move everything to server #3). The configuration is below:
OS - Windows 2003 server R2, SP2
domain - one
servers - 3
Server #1 - manages computer group 1
Server #2 - manages computer group 2
Server # 3 - manages computer group 3
Each server has its own SEC
SEC version 3.11
SQL 2000 standard for each of the server
My questions are:
Can you merge the three databased into one? Since the data structure is the same for the three servers, can you use SQL import/export to add the addition data?
Assumming the database can and has been "merged" into one, what do I need to do to make sure clients from server #1 and server #2 will talk/report to the new (server #3).