TABLE OF CONTENTS
- Microsoft .NET Framework Versions
- Microsoft SQL Server Versions
- Database Compatibility Level
- ManagementStudio v13 to v14 Portal Upgrade
- Authentication
Important: Rolling back from version 2025.14.x.y to earlier versions is not possible due to significant changes made to the database tables. It's advisable to back up the database before upgrading.
Microsoft .NET Framework Versions
MS Server
- Upgraded from .NET 7 to .NET 8.
- .NET 8 is included in the server installation and does not need to be installed separately.
- The server requires the .NET Hosting Bundle v6 or higher. For upgrades, the previously installed hosting bundle is sufficient.
MS Client
- Upgraded from .NET 4.8 to .NET 8.
- .NET 8 is included in the client installation and does not need to be installed separately on the client desktop.
Microsoft SQL Server Versions
- The supported version of SQL Server has been changed to SQL Server 2016 SP1 and above
- SQL Server 2012 is no longer supported
Database Compatibility Level
- If upgrading the database through an in-place upgrade of SQL Server or migrating to a newer SQL Server, ensure the database compatibility level is set to at least 130 (SQL Server 2016 compatibility).
- Refer to Best Practices for Upgrading Database Compatibility Level for more information.
Check Database Compatibility Level
Run the following SQL command to check the compatibility level of your database:
SELECT name, compatibility_level FROM sys.databases;
The values shown should be 130 or higher.
Change Database Compatibility Level
To update the compatibility level to match your SQL Server version, use the following SQL command:
ALTER DATABASE [ManagementStudio] SET COMPATIBILITY_LEVEL = 130;
ManagementStudio v13 to v14 Portal Upgrade
- After upgrading, if your Portal was being used to provide pages for users to view and interact with lists of applications, users, devices, etc., those pages must be converted to their V14 equivalents.
- Any v13 Portal Forms (Surveys) used to create new Apps, Devices, etc., must be updated, ensuring that the "Is New Item" checkbox is checked.
- For v13 Portal Forms (Surveys) that served as both "new item" and "view item" forms, you must duplicate the "view item" form. Portal Forms in v14 can no longer handle both functions.
The default behaviour of v13 Surveys where Processes and Sub-Processes were read-only has changed in v14 to read-write by default. If you have any surveys that show the Process and/or Sub-Processes, they should be updated to read-only, unless read-write is required.
Authentication
- To fully utilise v14 Portals, it is recommended to enable Windows Authentication, Azure Authentication or both in IIS.
- To enable authentication, you will need to:
- Update the web.config file directly on the server.
- Install the necessary IIS role.
- For more details, refer to the support article.