I am in the process of upgrading my Magento website. I have started with a clean slate and done a fresh install of Magento 1.9.1 on a dev URL.
I imported my current LIVE database and performed the upgrade, and then began site development on the DEV site.
The LIVE site is still taking new orders, and having new products uploaded to it, as business must continue, of course.
When I am ready to launch the new site, how do I go about making sure the DEV site contains all of the LIVE sites products, customers and sales history, and anything else that is required along those lines.
There are a number of threads out there talking about dropping the DEV database and rerunning the upgrade on the LIVE database (once restored to the DEV database) and then launching - but all my site modifications stored in my DEV database would be lost if I did this!
I imagine there is a way to just copy the relevant data from the LIVE database to the DEV database to bring it up to date, and then I would be able to launch the new site. That being the case, can someone provide a list of the relevant tables that would need to be copied from the old LIVE to the new DEV database.
Sub-question... how do you get around the problem of any differences between the old (1.6.2) database and the new (1.9.1) database tables to be copied?
I hope someone can help.