Upgrading an old OSC pre MS1 to OscMax v2.

[cabana]

Has anyone had any luck moving over their customer databases from an old store to a new install. I would really like to upgrade to OscMax but I also have a customer base of 11,000 that I really want to move with me.

In a perfect world I would also like to move their order history as well. I understand that may be much harder so I can live without that if I have to. Any suggestions or instrustions would be greatly appreciated.

Josh

[michael_s]

Josh,

It is not too difficult with the right tools. Grab a copy of mysqldiff and you should be able to do a structure upgrade without too much trouble.

The steps are as follows:

1. Make a duplicate of your original, and use this to do all your work on. (obvious, but I want to make sure).
2. Get Mysqldiff and install it. Then run it, comparing the duplicate against a stock osCMax2 database to get a sql batch file that will allow you to upgrade the structure of your duplicate to osCMax. Run the batch file on your duplicate database, upgrading the structure.

3. Once completed, export your upgraded product, customer, order data to an sql batch file, then run that on the osCMax database.

4. Check to make sure everything is happy. Done.

I have simplified the process, and most likely you will run into some problems while upgrading the addressbook table, as the primary key has changed from MS1 to MS2, which my cause your upgrade batch file to choke. If that happens, you will have to manually remove the primary key, and do a little data fixing by hand...

Good luck!

[cabana]

Sounds great. Thanks for the suggestion. I will give it a try.

[michael_s]

I have done it many times, so if you get stuck somewhere, come back for assistance.

[kenlyle]

In another thread, I looked at this with a more primitive tool, a regular file compare tool. What I remember is that it looks like there is one primary key that has changed, but that most of the diffs are new tables and fields in the new version's database. That thread is, as above, "Database Structure Comparison OSCMax 1.7 vs. 2RC2"

If I can get away with it, I am just gonna export my old database with complete and extended inserts, and try to stuff it into the new database.

K

[jpf]

No harm in trying - just backup first!

[mq-james]

I've followed this guide, i've got the catalog etc exported, but all the prices are 0, Any ideas what could cause this?


Thanks
James

[jpf]

If prices are ZERO then somthing did not work with MYSQLDIFF - if you did not use it (use a file diff tool) -then that would be the reason.

Reinstall mysqldiff and try again...

[dmiles]

OK, help please.

1. How do I make a copy of the original database?

2. Where do I install Mysqldiff?

2. Where do the two databases need to be to be seen by Mysqldiff?

Thanks

[Redeye_Joe]

I am in the process of doing this also, and I just did it the hard way, compared new database, with old, modifing old, then inserting in to new.
A pain in the butt, but so far so good...