upgrade and retain existing data

[MrTemplate]

I have an OSComerce shopping cart. In the credits, it says that it's from 2003, and the copy of the credit screen says:

 

 

SHOPPE ENHANCEMENT CONTROLLER v2.2

for osCommerce MS2 with Credit Class and Gift Voucher

 

this software is ancient and hard to work with. i want to update to a current version of osCommerce. can i update and retain all of the existing data from the 2000 customers who have purchased product from my shopping cart dating back to 2003?

[♥toyicebear]

you can do it in 2 ways... (as always make and save backups)

 

1. Compare your old db structure with V2.3.3.4 db structure and add over changes to the old db, you can then use the old db with a new install of v2.3.3.4.

 

or

 

2. Make a brand new install of v2.3.3.4 and then import over customer/order/product/category data from the old db into the new db.

[♥bruyndoncx]

I did 1. but the tricky bit is the contents of the configuration table.

 

2. is the easier option I think, and you then start of with a clean install just with the necessary data.

[Guest]

@@MrTemplate

 

2 is the only option as there are far too many updates to apply to an old MS2 store to bring it up to date. You would end up with a 'frankenstore'

 

 

 

Chris