Migration of DB tables

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6

dear team, after finally fixed all issues on a clients website, we would like to proceed with migrating all the necessary DB tables for hikashop from the old site to the new site. this is our setup:

OLD SITE:
joomla: 3.4.7
hika: 2.5.0

NEW SITE
joomla: 3.4.8
hika: 2.6.1

what are the tables to migrate?
is there anything we need to be aware of`? (maybe new columns in the new hika version etc.?)

Hi,

The best would be to create a new development environment and duplicate the old site.
Then on this dev version, update HikaShop to the latest version, the 2.6.3, same thing for the new site, update it to the latest version. Then migrate all the HikaShop tables from the old to the new site, that way you are sure to migrate all the data and using the dev environment will not broke the production website.

You will need to have the latest data from the Joomla user table up to date too, but this is a Joomla thing

thank you for the quick reply!

we did that already.
NEW SITE is the duplicate dev environment of the OLD SITE (see my first post).
OLD SITE is right now the LIVE SITE, which will be switched to NEW SITE as soon as we finished migrating the tables (orders etc.?)

problem is, we cannot update HIKA on the OLD SITE (which is currently live and on another server we dont have access).
but we need (and can) to import the orders from the OLD SITE (currently live) to the NEW/DEV SITE prior to the switch.

have there been changes to the table structures we need to migrate, from hika 2.5.0 to 2.6.1 ?

1. if yes, can you help in finding a solution on how to migrate (eg. what columns should we add to the tables of the DB)?
2. if not, what are the hika tables we need to migrate?

that is also an option. thanks for the suggestion, we will think of it.
but the most important thing is our question:
- what are the hika tables we need to migrate?
(in order to have all shop orders up to date)
(we are planning to manually add the new entries)
PS. we do not use a user login, so i guess not users need to be imported from joomla?

i suspect the following tables (please confirm):

_hikashop_address 	= 1981 entries
_hikashop_history 	= 1486 entries
_hikashop_order  	= 1483 entries
_hikashop_order_product = 3190 entries
_hikashop_user		= 1277 entries

Hi,

Yes the main table to migrate are the ones you mentioned.
In some case the table "_hikashop_file" could be useful too.

all worked great, i did not even need to fix any tables!

In Components >>> Joomla update ... options ... set LTS save and close. Purge cache. If no update shows then use the extension manager to install the latest version
Install a fresh latest version without sample data
export/import from original to new version
In the new Components >>> Joomla update ... options ... set STS save and close