Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 10 of 10

Thread: Upgrading an old OSC pre MS1 to OscMax v2.

  1. #1
    cabana
    Guest


    Default Upgrading an old OSC pre MS1 to OscMax v2.

    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

  2. #2
    osCMax Developer


    Upgrading an old OSC pre MS1 to OscMax v2.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,014
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default RE: Upgrading an old OSC pre MS1 to OscMax v2.

    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!
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    cabana
    Guest


    Default RE: Upgrading an old OSC pre MS1 to OscMax v2.

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

  4. #4
    osCMax Developer


    Upgrading an old OSC pre MS1 to OscMax v2.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    23,014
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    594


    Default RE: Upgrading an old OSC pre MS1 to OscMax v2.

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

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    kenlyle
    Guest


    Default Database Structure Comparison OSCMax 1.7 vs. 2RC2

    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

  6. #6
    jpf
    Guest


    Default RE: Database Structure Comparison OSCMax 1.7 vs. 2RC2

    No harm in trying - just backup first!

  7. #7
    mq-james
    Guest


    Default

    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

  8. #8
    jpf
    Guest


    Default

    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...

  9. #9
    dmiles
    Guest


    Default

    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

  10. #10
    Redeye_Joe
    Guest


    Default

    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...

Similar Threads

  1. Upgrading from MAX v1.7 to v2.0
    By rbudj in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 08-06-2005, 11:20 PM
  2. Upgrading from osCommerce to OscMAX
    By pixtonjp in forum osCMax v1.7 Installation
    Replies: 2
    Last Post: 05-18-2005, 10:43 AM
  3. Upgrading a modified OSCMAX 1.5.5 to 1.7
    By icecold in forum osCMax v1.7 Installation
    Replies: 1
    Last Post: 04-07-2005, 02:52 PM
  4. upgrading 2.2 >> 2.2ms PLEASE HELP
    By Rodland in forum osCommerce 2.2 Installation Help
    Replies: 3
    Last Post: 04-02-2003, 07:23 AM
  5. Upgrading from 2.1 to 2.2
    By Anonymous in forum osCommerce 2.2 Installation Help
    Replies: 1
    Last Post: 11-19-2002, 04:31 PM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •