osCmax v2.5 User Manual
Results 1 to 8 of 8

Database Structure Comparison OSCMax 1.7 vs. 2RC2

This is a discussion on Database Structure Comparison OSCMax 1.7 vs. 2RC2 within the osCMax v2 Features Discussion forums, part of the osCmax v2.0 Forums category; This is a diff, using Beyond Compare. I use this to tell me what to expect when I move my ...

      
  1. #1
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default Database Structure Comparison OSCMax 1.7 vs. 2RC2

    This is a diff, using Beyond Compare. I use this to tell me what to expect when I move my data from one database to another.

    I hope this is helpful to someone. If it's old news, or redundant, or something, let me know, too.

    Thanks,
    Ken

  2. #2
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


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

    Looks good to me.... However I would not use this DIFF package to upgrade... Use MYSQLDIFF tool would be MUCH safer/easier....
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  3. #3
    New Member
    Join Date
    Oct 2004
    Posts
    16
    Rep Power
    0


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

    Is there an alternative to MYSQLDIFF tool? It does not work on my shared server.

  4. #4
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


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

    Set it up locally on your development computer, and do your 'diffing' from the desktop...
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default Circumventing the Diff

    Gents,

    If the diff, using whatever method, shows that the only issue appears to be added tables and fields (and maybe that one primary key change)....

    If you just do an export of the old database with complete and/or extended inserts, that will make sure that all the fields align themselves correctly.

    I've been lucky with this in the past.

    Or should I suck it up, and learn a new tool, for my own good?

  6. #6
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default RE: Circumventing the Diff

    Is not hard to learn.... Beyond Compare is a great tool however it is still DUM about correct SQL script. Like I said at first glance - it looks good. No harm in trying..provided all has been backuped...perfered if you tested on a "test" site (see below).

    As for setting up a 'localhost' (to do your delveloping/testing ect.. on your local PC) - download a WAMP like EasyPHP to install Apache/MySQL/PHP on your local computer. 30 sec install - load the program - PUT the files in the WWW or web directory (each wamp is a bit differnt where this is - but can be changed if need be) - Go into phpmyadmin and setup your MYSQL username & password. Then load up your perfered browser like FireFox and put 'localhost' as the URL...good to go!
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  7. #7
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default RE: Circumventing the Diff

    OK, ya big stud. I tried installing mysqldiff on my hosting account, and couldn't connect to my databases, even though I can use ODBC to connect to them.

    I read some stuff about WAMP, etc., that the uninstalls can be messy.

    Is there a chance that you can run this 107->2.0 mysqldiff and post it for those of us less technically fortunate?

    Thanks,
    K

  8. #8
    Member
    Join Date
    Jul 2005
    Posts
    91
    Rep Power
    0


    Default MySQLdiff script database conversion 1.7 to 2.0

    I reinstalled mysqldiff, and found a few bugs, but the script at least ran to completion, although I had to re-run the section where it failed.

    This script will convert the database to the new structure. I'd suggest running it against a copy of your production database, of course.

    I will be assessing whether the patched database works under the 2.0 RC2 code base. Anyone care to join me?

    Thanks,
    K

Similar Threads

  1. New to OSCMax 2.0 - looking for a fair comparison
    By djgizmo in forum osCMax v2 Features Discussion
    Replies: 6
    Last Post: 10-24-2006, 03:26 PM
  2. how do i convert oscommerce database backups to oscmax?
    By chuan in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 10-07-2006, 06:43 PM
  3. Point of Sale program that will use Oscmax database?
    By Redeye_Joe in forum osCmax v2 Customization/Mods
    Replies: 3
    Last Post: 02-07-2006, 11:18 PM
  4. OSCMax v2 - Stuck on New Installation Database Import
    By Geno11x11 in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 12-04-2005, 09:27 AM
  5. Printing the Database Structure PDF
    By DenverDave in forum osCommerce 2.2 Modification Help
    Replies: 1
    Last Post: 04-10-2003, 01:50 PM

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
  •