migrating customer and order data ONLY

[ketok]

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

[kuroi]

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

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

[swamyg1]

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?