Hmm... I need to find out myself. I don't know what is the answer. I'll do some Googling and get back to you if I got an anything. You should email the people at iContact as they probably could give you an answer..
Instead of wasting all that paper, why not just open both versions of install/oscommerce.sql in a comparison program? I just did, and it took only a minute to scan through all of the changes using Meld..
It appears that you can just import all of your data without any problems. There are some new tables, so I would do a full install first, then overwrite.
Just the data.
With your 2.2 backup..
Once you have all the data in, there are a few things that you will need to do manually, like go enable all of the reviews..
That's all assuming that your database is still stock 2.2 MS2 or later. If you have addons that changed the database, you need to export your database structure and compare that instead..
I wanna do the same, my 2.2 is full of old no longer working contributions that I would like to get rid off..
The DB is not all that different. Some extra configuration bits, the reviews_status, the extra images. Other than that, there are a few changes in length (eg admin and users passwords)....
What I'd do is install 2.3.1..
Drop the database tables..
Repopulate with 2.2 database..
Remove all non-standard tables and any extras that were inserted by contributions..
Add in the extra database bits from 2.3.1.
Should go fairly smoothly in theory...
That's the point I was getting at - I don't think I've ever seen an osC build "in the wild" that was "stock"..
There's also quite a surprising number of contribs that modify the database, though admittedly, most simply add their own tables rather than change existing ones. I would still want to do an export of the structures and compare them - little things like a field length difference can really screw up your data if it causes a truncation..
The other thing no-one mentioned yet is where fields contain a structured array - I haven't checked yet if there's any difference in any of the saved query arrays, I'd expect not, but it's best to check them...
I've seen quite a few osC stores that were essentially stock cosmetic changes only. And at least one that was totally stock..
Most of the changes to the tables in 2.3.x are to make fields longer. Most of the varchar fields were maxed out. Of course some addon could have changed the type, so you need to be careful of those. That's why I suggested the use of a comparison program like Meld..
I haven't seen any problems with the config arrays, but I haven't looked that carefully. I'll do that. And for practice, I just imported a store with about 5000 products into 2.3 with no problems. It's running on a test iContact site of course. The live version is running a heavily modified 2.2RC2a, so I had to add quite a few tables and add some fields to existing ones, but otherwise the import went smoothly. No problems so far..
Sorry about this but could you be a bit more specific? I tried your instruction but I'm getting lost, how do I know what are none-standard tables and what is extra that has been inserted?.