Version: 2023-R1-SR2 (5.2.1)
Release date: 27 June 2023
The Perfion Database Installer is needed to install a new database or upgrade an existing Perfion database to the latest release.
NOTE: The Perfion Database Installer requires the sqlserver to use CI (Case Insensitive) collation as its default collation - it will not work if temp/master DB is using CS collation. Workaround is to install a new named instance on the sqlserver with a CI collation.
Related guides:
Release notes
2023-R1-SR2 (5.2.1)
Release note title | Release note |
|---|---|
New Indexes at Specs | For performance optimization four new indexes are added to table Specs: IX_Specs_SpecType, IX_Specs_String, IX_Specs_Number and IX_Specs_Date. |
2023-R1 (5.2.0)
Release note title | Release note |
|---|---|
Foreign key on table MultiFactorAuthentication changed | Delete Cascade added to the foreign key FK_MultiFactorAuthentications_to_Users on table MultiFactorAuthentications. |
Action Commands and Job Execution | Action Commands and Job Execution is refreshed in the database and it is not possible to edit the data in the clients anymore. |
Support for MS SQL server version 2022 | Perfion is now supporting MS SQL server version 2022 |
Table Designer Style added to Database installer | A default Table Designer Style added to the Database installer, so new Databases include a default style |
Installation of Actions, Table Features and ECommerce | The installation of Actions, Table Features and ECommerce is moved from Settings to the DB installer. The installation will automatically be executed when the system is updated to 2023-R1 or above. |