VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: sprachrohr on February 25, 2016, 17:52:10 PM

Title: Best way to transfer data from VM2 Tables to VM3 tables
Post by: sprachrohr on February 25, 2016, 17:52:10 PM
Hi,

i have a production live shop (Joomla 2.5.28 and VM2) currently running. Now i want to make an update. At the moment i do all the updates (Joomla 3.4.x and VM3) on a testsystem. During that time new orders are placed in the old shop.

What is the best way to get these orders and the related users into the new system?

Thanks for your answer.

Best regards
Title: Re: Best way to transfer data from VM2 Tables to VM3 tables
Post by: PRO on February 25, 2016, 22:49:01 PM
Quote from: sprachrohr on February 25, 2016, 17:52:10 PM
Hi,

i have a production live shop (Joomla 2.5.28 and VM2) currently running. Now i want to make an update. At the moment i do all the updates (Joomla 3.4.x and VM3) on a testsystem. During that time new orders are placed in the old shop.

What is the best way to get these orders and the related users into the new system?

Thanks for your answer.

Best regards


what I did.

I had a separate development site.
I then brought in the latest LIVE version over. ran the migration.

THEN: moved ONLY the users, and order stuff over to the real development from the database.
make sure you DROP the tables before importing the new ones, because the auto increment of some of the tables will mess you up.


TEST TEST TEST TEST

Title: Re: Best way to transfer data from VM2 Tables to VM3 tables
Post by: GJC Web Design on February 26, 2016, 00:34:53 AM
Yes.. I do the same

clone the original and update the bare minimum so I have a usable set of J3/VM3 tables

export and import the  tables - J user , vm user, orders and products after backup, backup backup and drop

and then as pro says test test test

the trickiest is if there are new users.. the j user and VM user has to coincide

If anyone knows a shorter/easier method please post as it is a common scenario
Title: Re: Best way to transfer data from VM2 Tables to VM3 tables
Post by: sprachrohr on February 26, 2016, 12:18:10 PM
thanks for your answers!

I was afraid you might say that. That means that offline time might be very long and maybe there are tons of errors  :'(

maybe someone knows a better / shorter / less error-prone method?
Title: Re: Best way to transfer data from VM2 Tables to VM3 tables
Post by: PRO on February 26, 2016, 15:43:49 PM
Quote from: sprachrohr on February 26, 2016, 12:18:10 PM
thanks for your answers!

I was afraid you might say that. That means that offline time might be very long and maybe there are tons of errors  :'(

maybe someone knows a better / shorter / less error-prone method?

this can be done in 15 minutes after practicing

tables are here.
http://forum.virtuemart.net/index.php?topic=103041.0

^^^ BUT!!! that thread is NOT your instructions, it is kind of the opposite.