Hi,
I'm working on migrating our current documentation server from Umbraco 8 to the latest version (time of writing 14.2.0).
I have successfully migrated from a .sdf file to an SQL database, and migrated project to v10.5.1 following the guide at
https://docs.umbraco.com/umbraco-cms/v/10.latest-lts/fundamentals/setup/upgrading/version-specific/upgrade-from-8-to-latest and then to v12.0.1 following steps on
https://docs.umbraco.com/umbraco-cms/fundamentals/setup/upgrading#upgrade-to-a-new-major.
Next step is to migrate from v12.0.1 to v14.2.0 following the instructions, but I'm getting error messages that the database cannot be migrated.
To see if there is a breakoff where the migration stops working I have worked myself back through the versions, successfully going through v10.8.6, v11.5.0, v12.0.0, and finally v12.0.1.
When I get to v12.1.0 the project won't even build.
I have tried upgrading directly to v14.2.0, but I get an error message similar to the following. I have also tried making smaller upgrade steps; to v13.4.1, to v12.3.10 but I run in to the same error.
The database failed to upgrade. ERROR: The database configuration failed with the following message: An explicit DROP INDEX is not allowed on index 'umbracoContentVersionCultureVariation.IX_umbracoContentVersionCultureVariation_VersionId'. It is being used for UNIQUE KEY constraint enforcement. Please check log file for additional information (can be found in 'LoggingSettings.Directory')