Maintaining database integrity during upgrades
📘 Instructions
PrinterOn uses Flyway to manage the PrinterOn products’ database versioning. This product creates a specialized table in the PrinterOn-dedicated database to manage modifications between versions and upgrades. This table is a critical piece of the PrinterOn product upgrade process and helps to ensure that the integrity of the database is maintained. PrinterOn creates a dedicated database instance in SQL Server to ensure that there is no impact with other databases deployed on the same instance.
As a result, the state of this Flyway table mustn't be modified after it is created, either manually or through any other application. If any third-party application or process modifies this Flyway table, it will have a negative impact and will likely break future upgrades of the product.