The specifications described below are indicative and do not take into consideration the special circumstances of an installation - especially in terms of the number of operators and their networking issues.
The RDBMS must be selected based on criteria relating to the bases themselves. The parameters considered for the selection of the RDBMS type should not include Soft1.
SoftOne equally recommends the two predominant RDBMS brands, without any feature of the applications and services favoring either option.
RDBMS (Online mode)
|RDBMS (Offline mode)||Microsoft SQL Server SQL Express 2017 & 2019||Microsoft SQL Express 2012 & 2014|
In case of Microsoft SQL Server, the required Collation Parameter of the base should be SQL_LATIN1_General_CP1253_CI_AI.
In case of Oracle, the required Collation parameter should be EL8MSWIN1253.
|1036||1252||French_100_CI_AS (Sql Server 2008+)||FRENCH||FRA|
The specifications for the database server (should be) specified by the RDBMS manufacturer. Strictly as an indication:
|Disk||NVMe / SSD / SAS / SCS I||SATA III +|
In certain installations, it may be recommended to use more than one application servers.
The specifications for Clients are applied as described below (you should prefer the specifications listed under the column "Recommended".
Windows 10+, 64- bit
|Windows 7 / 8 / 8.1 / 10+, 32-bit|
FullHD 1920 * 1050 (ideal)
Wide screen 16:9
Client Connectivity Tools (by the RDBMS manufacturer) will be required in the following cases:
Client Connectivity Tools will not be required in clients' machines (usually remote) which do not operate (additionally) as Application Servers but communicate with an Application Server on a separate machine (possibly the same as the one with the DataBase Server)
Note: The client tools of the database must be installed on the other computers as well, except server computers, in accordance with the database manufacturer's instructions. In the case of a remote terminal, it is not required to install the client tools of the database because the client-server application model will be used.
An Internet connection is recommended in order to utilize SoftOne Services.
Microsoft SQL Server Express is a powerful and reliable free data management system for small-scale Soft1 installations, with no more than 5 users (web users included too).
Here are some of the most important differences of the SQL Express compared to SQ Standard Edition:
|SQL Standard||SQL Express|
|Maximum Database Size||524 PB||10 GB (1)|
|Compute Capacity||4 sockets or 24 cores||1 socket or 4 cores (2)|
|Maximum Memory||128 GB||1.4 GB (3)|