<div>
<div class="content wysiwyg-content">
We have installed an application, which records transactions on a local dbms (sql server express), on each branches.<br />
<br />
We have around 100+ branches and the data will be uploaded to the central server once a day. There will be around 1GB of data per day.<br />
<br />
The central server will also maintain a TCP/IP connection to all the branches for real-time monitoring.<br />
<br />
The central server will be used for centralized monitoring and reporting for all the branches. Currently, I don't know how many users will be accessing the monitoring and reporting applications.<br />
<br />
Please recommend which Windows version/edition to use.<br />
<br />
Thanks
</div>
</div>


We have installed an application, which records transactions on a local dbms (sql server express), on each branches.

We have around 100+ branches and the data will be uploaded to the central server once a day. There will be around 1GB of data per day.

The central server will also maintain a TCP/IP connection to all the branches for real-time monitoring.

The central server will be used for centralized monitoring and reporting for all the branches. Currently, I don't know how many users will be accessing the monitoring and reporting applications.

Please recommend which Windows version/edition to use.

Thanks

Windows Server OS for central database server

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.