Prestashop 1.7.6.4 to 8.1.2 SQL schema dbdiff

[Diwad]

Hello. Anyone of you have sql file with all the differences between 1.7 and 8.1.2? I have test server ready and 1.7 database with over 1GB data. I want to import products, customers, categories, etc but not modules tables because there are some leftovers from uninstalled modules.

I’m looking for easiest way to import the database. I imported it and backoffice works, just some tables are missing. I added few by hand in phpmyadmin, but I want to make sure it works as it should.

I also tried prestaheroes Migration tool but its not working as intended, as most of their module I bought in the past…

[Nickz]

I think

This could help: https://build.prestashop-project.org/news/2022/migrate-your-solutions-from-17-to-80/

[Diwad]

I saw this, but I thought someone has ready to use sql with all those changes in schema:)

[Nickz]

I think prestashop is moving in direction SaaS which is not that good for anyone of the prestacrowd.
They leave a skeleton server side version for the people to play with, such as shopware. 

[musicmaster]

Try my tool: https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-upgrading-and-fixing-buggy-shops-by-copying-business-data-and-images/

It will work

[Diwad]

Will try. I know your tools are amazing:)

Meanwhile I upgraded old install but good to know

 

[JBW]

You can find all SQL updates in 1-click-upgrade module at modules\autoupgrade\upgrade\sql

Most recent structure is here:

https://github.com/PrestaShop/PrestaShop/blob/develop/install-dev/data/db_structure.sql