Article 3.6.1V : SQL server express edition to standard upgradation details.

Article 3.6.1V : SQL server express edition to standard upgradation details.

required details for Database storage up to 10 to 15 years with time interval of Data-log 15 min based on relation DB creation.

Kindly go through below details for that :

1. Why to Upgrade.
Reason:  As per present SQL server running in your system is SQL 2014 express, Which have storage capacity up to 10 GB provided by Microsoft for 1 DB.  That 10 GB DB is filling with in 1-2 month(1 min data log interval) or 15 to 18 months(15 min data log interval). To resolve this issue your required to upgrade SQL server standard version. Which provide by Microsoft up to  524 Petabytes for DB. Based on your hard disk storage data can store.

2 Purpose of SQL Server.

SQL is a special-purpose programming language designed to handle data in a relational database management system. A database server is a computer program that provides database services to other programs or computers, as defined by the client-server model. Therefore, a SQL Server is a database server that implements the Structured Query Language (SQL).

There are many different versions of Microsoft SQL Server, catering for different workloads and demands. A data centre version is tailored to higher levels of application support and scalability, while the Express version is a scaled down, free edition of the software.


3. Technical and performance difference between existing and proposed version of SQL server.
Kindly refer below document.

4. Time of delivery.
From 1 week from PO release date.

5. Time required for up gradation
With in 4 days from delivery of CD( system required with below mentioned specification to proceed sql installation)

6. Training.
you can proceed to take on operation in our software as usually. No need training again.

7. existing data compatibility

1GB maximum memory used by the SQL Server Database Engine

The maximum size of each relational database is 10GB

SQL Agent is not included in Express. The SQL Agent is a background tool which enables administrators to automate tasks like backing up data, database replication setup, job scheduling, user permissions, and database monitoring.

The limit on the buffer cache for each instance is 1MB of RAM.

The relational database engine is restricted to the lesser of 1 socket or 4 cores.


PC requirement to install SQL standard version:

1) 32 GB ram, 10 TB HDD, 

2) 4 socket or 24 core compute capacity, 

3)  i7 processor 64-bit, 

4) windows 8 or above OS 64-bit  licence version,  MS-office.


Kindly find below attachment.