Migrating to v14.2
# help-with-umbraco
b
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')
When trying to v12.1.0 I get: InvalidOperationException: Error while validating the service descriptor 'ServiceType: Umbraco.Cms.Persistence.EFCore.Migrations.IMigrationProvider Lifetime: Singleton ImplementationType: Umbraco.Cms.Persistence.EFCore.SqlServer.SqlServerMigrationProvider': Unable to resolve service for type 'Microsoft.EntityFrameworkCore.IDbContextFactory`1[Umbraco.Cms.Persistence.EFCore.UmbracoDbContext]' while attempting to activate 'Umbraco.Cms.Persistence.EFCore.SqlServer.SqlServerMigrationProvider'.
Actually, when I tried v12.2.0 the project runs again, but now I get the dreaded 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')
Update: I was able to manually remove the offending index. After that I could update to v12.2.0, then v12.3.10. After that I got another error "The database failed to upgrade. ERROR: The database configuration failed with the following message: Column 'dataRaw' in table 'cmsContentNu' is of a type that is invalid for use as included column in an index." Found a solution to the problem here: https://our.umbraco.com/forum/using-umbraco-and-getting-started/114215-error-upgrading-from-1150-to-1332 (thank you umbraco support forums!) I was able to manually fix that by adding a new column with the right datatype (varbinary(MAX)), copy data from dataRaw to the new column, delete dataRaw column and then rename the new column to dataRaw. 😅 Eventually I have been able to update to v13.4.1. So... success?
5 Views