Issue
The On Premise Nintex Promapp upgrade for a client fails with errors when running the SQL migration scripts.
Resolution
Check if their SQL server meets the minimum specifications included in their upgrade package (Currently SQL Server 2017). If this is correct, ask them to run the following commands on their Nintex Promapp Daabase:
SELECT compatibility_level
FROM sys.databases WHERE name = ‘Promapp_database_name_here’;
If you see anything less than 130 in the output, the following should be run:
ALTER DATABASE [Promapp_database_name_here] SET COMPATIBILITY_LEVEL = 130
At this point the compatibility level should be right. They can then retry the scripts that are failing.