Migration script old osCommerce version.

[w2vy]

I see the migration script on the TODO list but no issue, so here's one...

I have a osc 2.3.2 shop that I need to upgrade to PHP8

I am one of the old core devs from a long time ago...

[w2vy]

osc232 is my existing db and vosc is yours

tom@w2vy:$ mysqldiff --server1=xxxxxx@localhost --server2=yyyy@localhost osc232:vosc
WARNING: Using a password on the command line interface can be insecure.
server1 on localhost: ... connected.
server2 on localhost: ... connected.
WARNING: Objects in server1.osc232 but not in server1.vosc:
TABLE: banners_history
TABLE: reviews_description
TABLE: counter_history
TABLE: whos_online
TABLE: banners
TABLE: counter
WARNING: Objects in server1.vosc but not in server1.osc232:
TABLE: information_pages_content
TABLE: customers_wishlist_attributes
TABLE: customers_wishlist
TABLE: oscom_app_paypal_log
TABLE: customers_braintree_tokens
TABLE: information_pages
Compare failed. One or more differences found.
tom@w2vy:~$

I can stand losing the reviews, I don't use banners and the counters won't be missed

The infomation_pages can easily be manually added, so maybe it won't be that hard.
Are there big changes in the configuration defines?

[w2vy]

I discovered that reviews_description was merged into the reviews table, happily I only had a couple dozen reviews so I migrated them by hand