Hey,
I research umbraco migration from v7.15 to v8.
I tried to do it so many times with no success, i got to the point its just running forever with no errors while slowly doing the same query over and over, making my cpu to overflow (i5 six 2.9hz cores).
The query is (@0 int, @1 uniqueidentifier) UPDATE cmsPropertyData SET versionid2=@0 where versionid=@1
It is working, but it takes days and it makes no sense.
Our site is around 1000 pages, the cmsPropertyData table contains 19m rows! I have no idea why.
Things i tried:
I switched all data types to the new ones (i dont care about the content for now, i just want it to pass migration first, its a demo for now).
I used sql scripts to clean all versions, leaving only the current one (i found it here in this forum)
Cleaned the recycle bins with a script (it was to big to empty from the backoffice)
And since treenodepickers data fields were too long, i used a tool to transform them to the new udi form.
Any other too long data fields that led to errors i just turned to null.
I think the key here is understanding why the table is so huge and if is it normal for it to be like that. My pc is quite strong, maybe not enough?
Thanks for any help given
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/108516-umbraco-update-takes-forever