Symptom: Running the mssql_upgrade_17.1_to_17.2.sql script the following error happens at the end:
==============================================================
ERROR: Occurred at Stage 3
Code: 245
Message : Conversion failed when converting the varchar value 'Disabled' to data type bit.
==============================================================
Cause: The script attempts to insert some values in a table without explicitly defining the column order. On some older databases, the columns were originally created in a different order, causing the issue seen in the error message above.
Solution: Run the attached modified version of the upgrade script, which will specify the columns in the correct order.
Comments