...
| Page Properties | ||||
|---|---|---|---|---|
|
Change Log
Date |
|---|
...
Change | |
|---|---|
| From the following product version MSql 2012 Is no longer a supported database. |
Overview
...
Main Office / Adonis Cloud
...
Adonis supports the following versions of MSSQL: 2022, 2019, 2017, 2016,2014, and 2012
For the host installation, we recommend going for a full version of MSSQL, but for the lesser installations on board, it will be enough to install the express versions. Express versions are free to use but have a restriction in database size and the amount of memory they can access. (It is important to remember when you replicate scanned documents to the vessels).
If a site is close to limiting what is supported by the express version, it is effortless to upgrade to a full version of MSSQL.
Limitations for MSSQL 2017 Express (Limitations for previous versions see Microsoft.com)
...
Database Server: MSSQL Server 2022, 2019, 2017, 2016, 2014, 2012
Hardware Requirements: http://msdn.microsoft.com/en-us/library/ms143506.aspx
Recommendation:
Memory: 6GB RAM (or more)
Hard disk: 120GB or more for the Adonis database (Estimated a 20-40 GB database on the office side. multiplied by 3 to have enough space for a backup to disk and restore as a secondary database)
...
Instead of running a SQL server in a virtual server, you may utilize the SQL Database offer in Azure. Our current minimum recommendation is an S2-level database. For production databases, we would recommend geo-replication to one or more additional data centres , to establish a disaster recovery solution.
...
For the Adonis Personnel Portal, instead of running a virtual machine with the portal, the App Service offer in Azure can be used.
However, be aware that the Personnel Portal installation/upgrade is an installation executable that is executed on an IIS server, so you would either have to run the installation/upgrade on a local computer or a virtual machine in Azure and then upload the installed directory structure to the App Service.
The recommended service level has not been determined yet, but a standard small App Service Plan can be a starting point.
An App Service Environment can provide better security but also come at a much higher cost. So you may have to consider your requirements for security v.s. the additional cost.
The App service should be running run in the same data centre as the database(both for performance and cost).
...