Operating System / SQL Server Compatibility
- Matthew Garrett
- Chris Grigsby
Operating systems not listed here are NOT supported. Please contact us, should you have any specific questions regarding software compatibility.
Server Version | v7.0 | v7.1 | v7.2 | v8.0 |
|---|---|---|---|---|
Windows Server 2022 | N | N | Y | Y |
Windows Server 2019 | Y | Y | Y | Y |
Windows Server 2016 | Y | Y | Y* | N |
Windows Server 2012 | Y | Y | Y* | N |
Windows Server 2008/R2 (64 Bit) | Y* | Y* | N | N |
Windows Server 2008 (32 Bit) | Y* | Y* | N | N |
Workstation Version | v7.0 | v7.1 | v7.2 | v8.0 |
|---|---|---|---|---|
Windows 11 | N | N | N^^ | Y |
Windows 10 | Y | Y | Y | Y |
Windows 8.1 | Y | Y | N | N |
Windows 8 (all versions) | Y | Y | N | N |
Windows 7 (64 Bit) | Y | Y | N | N |
Windows 7 (32 Bit) | Y | Y | N | N |
SQL Server versions not listed here are NOT supported. Please contact us, should you have any specific questions regarding software compatibility.
SQL Server Version | v7.0 | v7.1 | v7.2 | v8.0 |
|---|---|---|---|---|
SQL Database Compatibility Level (Maximum) | SQL 2008 R2 | SQL 2008 R2 | SQL 2008 R2 | SQL 2019 |
MSSQL 2022 | N | N | Y | Y |
MSSQL 2019 | N | N | Y | Y |
MSSQL 2017 | Y | Y | Y | Y |
MSSQL 2016 | Y | Y | N | N |
MSSQL 2014 | Y | Y | N | N |
MSSQL 2012 | Y | Y | N | N |
MSSQL 2008 R2 | Y* ^ | Y* ^ | N | N |
* Although Windows Server 2008 and SQL Server 2008R2 is supported by the software (subject to the notes/conditions here), it is not recommended that these be implemented into a new environment. Users are encouraged to periodically upgrade their operating system and SQL server versions in line with this compatibility information.
^ MSSQL 2008R2 compatibility:
MSSQL 2008R2 is not compatible for Framework ECM users if using the Framework Inbox (ie. email monitoring) solution. A minimum of MSSQL 2017 is required.
MSSQL 2008R2 is compatible for Framework ECM users when not running Construction Logistics. For users of Framework Construction Logistics (ie. typically Tablet/Notebook PCs) a minimum of MSSQL 2012 is required.
** Incremental security, UAC, and Integrity Level changes being released by Microsoft for Windows 10 may cause compatibility issues in some environments (or for users with certain security/UAC settings). Support for these changes/issues are not supported in older Framework versions.
^^Windows 11 Compatibility for Framework v7.2:
Please note that full regression testing of Framework v7.2 has not been completed with Windows 11
While many features of Framework v7.2 applications will operate without issue with Windows 11, this is not guaranteed.
Known issues do exist in some Windows 11 environments with the Logistics Tablet software’s inability to access Microsoft Outlook (32bit), which is prevented by Windows/Office.
Note: ODBC SQL Server client-side driver: from Framework v7.2 there is no restriction applied to the version of the SQL client driver that can be used
SQL Server Log Files
1. Log Files are used to track all changes in a database to, amongst other things, provide a point-in-time restore due to a failure.
2. To understand the volume of SQL Log File growth, you investigate what has been changed (and as such logged). Insula cannot assist with the analysis of log files, their growth, etc.
3. In terms of understanding Log Files and their size, growth, and management, Insula recommends implementing the appropriate Recover model for an organisation. Please review the official Microsoft documentation on this. eg. As a starting point - https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-ver15
4. In short, if an organisation's backup strategy is robust and point-in-time restore limitations are understood, a Simple recovery model may be suitable.
5. Where a different (ie. logging) model is used, periodic log shrinking should be done to ensure backups are complete, and logs are shrunk, to conserve disk space. This can be a scheduled/automated process and, again, should be done in accordance with Microsoft's official documentation.