The main two differences are in the editions of MSSQL used from the manufacturer (Microsoft): Standard and Express. The customer can purchase their own MSSQL directly from the manufacturer, or they may already have one of the supported versions (2016 and higher). In cases where the customer has their own edition of SQL Server, licensing is fully at the customer's discretion. PREMIER system offers its own MS SQL Standard license, known as the runtime version. The limits of the Standard and Express versions are stated above. Our "Run-time" version is identical to the boxed version from the manufacturer, but due to the advantageous price from our company, Microsoft has only one restriction: on such an SQL Server, it is only possible to use databases for the given software, namely PREMIER. It is not possible to use additional databases for other systems on the runtime edition.

Therefore, it is always advisable to consider which edition to use. The Express version is free, but it has limits that need to be taken into account. The maximum database size limit is unlikely to be a problem for most users, but the maximum used RAM on the SQL server could be an issue. For example, if the database is 8GB and the server has 32GB of RAM, the SQL process will use a maximum of 1.4GB of RAM. The Express edition is also not suitable in cases where a large number of users (more than 10) access the database, as this can affect the performance of the SQL processes themselves and thus the PREMIER IS.