8 to 10 Database upgrade error

[vale bridge]

I am trying to connect to a version 8 database in a clean v10 Umbraco, to allow the wizard to do the upgrade for me, but I run into this error

https://i.imgur.com/eYlJWkD.png

Setting the connectionstring to attach to a working v10 Database works fine, but on the v8 it gives the above error - Isn't there supposed to be a wizard?

Upon swapping to the 10 that works, and back to the 8 that I want to have upgraded, it won't even let me run the site anymore;

The v8 database is a copy of an in-production database

[tawdry lotus]

Don't hotswap databases, it will confuse Umbraco and its indices and caches I think.

Did you upgrade to 8.latest first? I think that's a must.

Did you follow the 8-to-latest-guide @astral berry mentioned the other day?

When you say "clean Umbraco v10", did you run the clean v10 first on a 10 database to make sure it works? If not, do that. But remove all indices and temp/cache files before attaching the 8abase.

Did you enable unattended upgrades? If so, disable it.

Yes, there is supposed to be a wizard. 🧙‍♂️

[vale bridge]

I used a clean installation that was already set up with a clean new database --- How do I remove those?

[vale bridge]

Where do I do this? - I don't recall going out of my way to make it enabled

[vale bridge]

I was assured that the Umbraco setup that the database was pulled from, was 8.latest

[tawdry lotus]

It's an appSetting. Default is disabled

[tawdry lotus]

Stop the iisexpress/kestrel, delete the index folder on disk, delete the temp folder on disk

[vale bridge]

Are both of those in the Data TEMP folder?

[tawdry lotus]

I think so. Delete the whole umbraco\Data\TEMP

[vale bridge]

Right, done - Then what?

[tawdry lotus]

Make sure all kestrels and iisexpresses are shutdown, connectionstring the 8abase, F5

[tawdry lotus]

If you get an error again, read the whole error message and check all Umbraco logs

[vale bridge]

https://i.imgur.com/IK0qycT.png

[tawdry lotus]

Inspect the entire callstack, and all Umbraco logs

[vale bridge]

I think this goes beyond my competence, as far as I am aware there's only a callstack that refers to a lot of "external code" but it starts and ends in the main function - And there are no errors in the logs from Umbraco

[astral berry]

Maybe I am misreading this but, I believe the thing we recommend in the docs is:

• do a clean v10 install
• stop the v10 site
• change the now existing connection string (in appsettings.Development.json) on the v10 site to the v8 database
• start the v10 site again
• you should now see the upgrade wizard - provided that unattended upgrades are not configured in the v10 appsettings

It might actually be beneficial to set unattended upgrades to true, I've seen one problem being avoided by that recently (can't remember exactly what).

Note: make sure that the v8 database is on the very latest: 8.18.14

[vale bridge]

I created a new project based on the 10.latest template, and created a database for it to go through the installation process with, I then closed the project to a production-based database from a v8 project that is currently live (So that database works), and when I start the project with the V10, connected to the V8 database, I run into the above error

[rigid widget]

Another option is to use uSync - Install uSync on v8 site, export everything. Then create a brand new v10 site with db, install uSync and import the previous v8 export. Maybe less paid unless you need all the v8 history

[astral berry]

Yeah I can't quite tell from the error what might be the problem. Indeed, as Simon says, my next option would be to use uSync to export from 8 and import to 10! 👍 It's a very excellent tool.

[vale bridge]

Does the database have a string for version?

[astral berry]

Kinda. It's a string for which migration has been performed last, in the UmbracoKeyValue table. It's a migration GUID though, you'd need to look at the Umbraco source code to figure out which GUID corresponds to which version.

Try uSync 😉