Endpoint Central extends support for using MS SQL database for storing the configuration and data. This document will explain the steps,
This migration is applicable only for Endpoint Central build 10 or above. Update your server here before following any of these steps.
Hardware Requirements for SQL Server
The hardware requirements for SQL server include the following:
|No. of Computers/Devices Managed||Processor Information||RAM Size||Hard Disk Space|
|1 to 250||Intel Core i3 (2 core/4 thread) 2.0 Ghz 3 MB cache||4 GB||5 GB*|
|251 to 500||Intel Core i3 (2 core/4 thread) 2.4 Ghz 3 MB cache||4 GB||10 GB*|
|501 to 1000||Intel Core i3 (2 core/4 thread) 2.9 Ghz 3 MB cache||4 GB||20 GB*|
|1001 to 3000||Intel Core i5 (4 core/8 thread) 2.3 GHz||8 GB||30 GB*|
|3001 to 5000||Intel Core i7 (6 core/12 thread) 3.2 GHz. 12 MB cache||8 GB||200 GB*|
|5001 to 10000||Intel Xeon E5 (8 core/16 thread) 2.6 GHz. 20 MB cache||16 GB||250 GB*|
|10001 to 15000||Intel Xeon E5 (12 core/24 thread) 2.7 GHz. 30 MB cache||32 GB||500 GB*|
|15001 to 20000||Intel Xeon E5 (14 core/28 thread) 2.7 GHz. 30 MB cache||64 GB||500 GB*|
|20001 to 25000||Intel Xeon (14 core/28 thread) 2.7 GHz. 30 MB cache||64 GB||1 TB*|
|25001 to 30000||Intel Xeon (20 core/40 thread) 3.6 GHz. 50 MB cache||128 GB||1 TB*|
* May increase dynamically according to the frequency of scanning.
Change the Endpoint Central Server Database to MSSQL
The following steps will explain you, to backup the data from the old server, change the Endpoint Central server database and restore the data in the MSSQL database.
Perform the steps below from the computer where MS SQL Server is installed,
Note: Ensure that the you configure Windows firewall to allow access to SQL server. Refer this document for more information.
From the computer where Endpoint Central Server is installed, perform the steps below:
Fig: Windows Authentication
Fig: SQL Server Authentication
It is recommended to click Test to check whether a connection could be established with the given credentials. This might take several minutes, the size of your database determines the time taken.
You can start using Endpoint Central which has been migrated from the previous location.