Thank you for your response, Matt T. We've been running Moodle on Azure SQL successfully for over a year and our preference is to stay with Azure SQL, if possible.
Furthermore, we have learned that Azure SQL is always ahead of the on-premise version of SQL in terms of updates and security patches. However, the standard 'Select @@version" command will always show version 12 when run against Azure SQL, regardless of the actual version.
Having said this, we would like to respectfully request that whatever pre-upgrade checks occur against our SQL database be updated to reflect this so that moving forward this is not a constraint for us to be able to continue upgrading our Moodle instance running on Azure SQL. Could you please change your code to be less restrictive? Please see this article FMI:
https://www.sqlcoffee.com/Azure_0002.htm
Furthermore, we have learned that Azure SQL is always ahead of the on-premise version of SQL in terms of updates and security patches. However, the standard 'Select @@version" command will always show version 12 when run against Azure SQL, regardless of the actual version.
Having said this, we would like to respectfully request that whatever pre-upgrade checks occur against our SQL database be updated to reflect this so that moving forward this is not a constraint for us to be able to continue upgrading our Moodle instance running on Azure SQL. Could you please change your code to be less restrictive? Please see this article FMI:
https://www.sqlcoffee.com/Azure_0002.htm