Forums / General Questions / migrating customer and order data ONLY

migrating customer and order data ONLY

Views: 981

Results 1 to 4 of 4
4 Jul 2011, 11:59 AM
#1
ketok avatar

ketok

New Zenner

Join Date:
Jul 2011
Posts:
2
Plugin Contributions:
0

migrating customer and order data ONLY

Greetings - we have two versions of the same site - a dev site and a production site. We cloned the live site in order to install and configure some add ons. Now that this is complete we would like make this modified site the new live site.

My question is, which specific tables from the current live site do we need to migrate into the new site so that customers and orders are up to date?

v1.3.9

thank u

4 Jul 2011, 1:55 PM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: migrating customer and order data ONLY

The ones that start "orders_", "customers_" and "address_".

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

4 Jul 2011, 7:34 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: migrating customer and order data ONLY

I always recommend going the OTHER direction. Keep the live site, and add the new settings to it. WAY SAFER than doing partial data copying from the live database. Invariably people miss data and then end up with problems. By always using the main database for your live data you won't lose order/customer or any other related data, nor will you run the risk of damaging the data in transport (such as special characters getting lost/damaged due to charset differences in export/import tools/files, files too big to import and then data gets lost, things missed due to insufficient study of the db schema and wrong assumptions made), etc.

While kuroi's statement is essentially accurate, it leaves out any data related to payment history logging and so on.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

15 Jul 2011, 3:13 PM
#4
swamyg1 avatar

swamyg1

Zen Follower

Join Date:
Dec 2008
Location:
San Fran
Posts:
382
Plugin Contributions:
0

Re: migrating customer and order data ONLY

DrByte:

I always recommend going the OTHER direction. Keep the live site, and add the new settings to it. WAY SAFER than doing partial data copying from the live database. Invariably people miss data and then end up with problems. By always using the main database for your live data you won't lose order/customer or any other related data, nor will you run the risk of damaging the data in transport (such as special characters getting lost/damaged due to charset differences in export/import tools/files, files too big to import and then data gets lost, things missed due to insufficient study of the db schema and wrong assumptions made), etc.

While kuroi's statement is essentially accurate, it leaves out any data related to payment history logging and so on.

Can you recommend a tool to use to do this? How can I look at and compare both databases to see what's changed?