Transferring the whole database from a python 2.7 framework to 3.11 framework

[mostwanted]

Hi guys, my app has been running on python2.7 since its inception, I have been reluctant to make the big change but now very critical updates a force the change. How do I move the entire database with all its images and data to the new app?

I have tried a few things and a few things, The appadmin interface import function is not working so I had to write a few scripts. Some tables without references were successful but I am stuck on bigger tables with images and table references I keep getting primarykey integrity error.

Please help

Regards

[villas]

There is not enough information here, but this seems like a DB problem rather than a web2py code error. 

You do not mention which DB.

It is not clear why you are re-building or importing to new tables etc.

When I upgraded (years ago),  I do not recall touching my DB at all (Firebird).

[Leonel Câmara]

You probably only need to do a fake migration after changing python version and clearing your sessions folder.

python ./web2py.py -S yourapp -M --force_migrate -D DEBUG --fake_migrate

The only incompatibilities are things that were pickled.