osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Merge Database

This is a discussion on Merge Database within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; I was wondering if there is a way to merge a db from OSC to OSC -Max. I have a ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 03-21-2005, 04:58 AM
Lurker
 
Join Date: Mar 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
extremest
Default Merge Database

I was wondering if there is a way to merge a db from OSC to OSC-Max. I have a lot done on my osc build and would like to upgrade to max but don't want to ahve to put all that info back in.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 03-21-2005, 08:13 AM
New Member
 
Join Date: Mar 2005
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
zonzo_1
Default

What i've been doing is taking a copy of the oscomm 2.2 data base, using the backup tool to create a comma delimited file then opening that up with exel and adding in any colums that do not match with the comma delimited file from oscomm MAX (there are new fields in some tables) and then appending that information to the one already from max and then running a restore. That usualy gets the job done for me .
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 03-26-2005, 11:12 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,665
Thanks: 2
Thanked 93 Times in 79 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
Default

Manually convert/change - That is best

I have also used a compare tool (use the MYSQL text dumps-the default backup format - and compare to your MAX database/backup) to add in what is missing - this has been what I have done in the past and works. Just "restore" the file in the new site (or use phpMyAdmin-SQL Query to popluate a fresh DB) and test...

Good Luck
__________________
JPF - osCMax Fourm Moderator
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
merge osc2 to oscmax2? chrismole osCMax v2 Installation issues 8 07-09-2006 01:20 PM
Visitors checkout cart does not merge Lady_Lobo osCommerce 2.2 Installation Help 1 03-23-2004 06:51 AM
Database marbor osCommerce 2.2 Installation Help 1 01-26-2004 06:33 AM
merge question jpr_eza osCMax v1.7 Discussion 0 10-02-2003 10:30 AM
What name should database be? Anonymous osCommerce 2.2 Installation Help 2 11-25-2002 05:31 AM


All times are GMT -8. The time now is 01:04 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax