Perfion Database Installer - Version 5.2

  • Updated

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.

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.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.