Magento – Magento data migration using two different servers

magento2-migration-toolmigration

My current Magento 1 site hosting on server which is not supported for Magento 2

So for the data migration and delta migration

I need to install my magento 2 on another server then need to remotely connect with Magento 1 database and then perform migration

My question is how to connect remote database with data migration tool ?

Is there any possibility to migrate data when magento 1 and Magento 2 hosted on 2 different servers.

Best Answer

Yes of course you can do this

You have to use your "external IP" instead of using "localhost", you also need to use "3306" port (if you want to use this method you have to be sure that you are allowed to connect using external IP, please ask your hosting to allow it).

I have this point before and But I had some difficulties to make connection between two server and to avoid this way, I only copied the database from old server to the new server (no need to copy Magento files only the DB), After this you can do the migration within the two DBs in the same server

Related Solutions

Magento – Magento 2 Data Migration Tool ignore unknown documents

Yes, You will have to add ignore for every table to avoid all errors in migration and for successful migration.

You can add ignore for all tables with specific extension. ie for ignoring all catalog tables you only need to add one statement:

<ignore><document>catalog_*</document></ignore>

This will ignore all tables starting with some specific extension.

I believe user must have answer for this but sharing this will help community members.

Magento – Installing Magento2 Data-Migration-Tool manual without composer

In case you run into this problem, check if your magento binary is working alright by running: bin/magento --version That should output the version number, but in my case it showed errors related to folder and file permissions. After running:

find . -type f -exec chmod 644 {} \;
find . -type d -exec chmod 755 {} \; 
find ./var -type d -exec chmod 777 {} \;
find ./pub/media -type d -exec chmod 777 {} \;
find ./pub/static -type d -exec chmod 777 {} \;
chmod 777 ./app/etc
chmod 644 ./app/etc/*.xml
chmod +x bin/magento

the magento binary was working fine and so was the migration command.

Best Answer

Related Solutions

Magento – Magento 2 Data Migration Tool ignore unknown documents

Magento – Installing Magento2 Data-Migration-Tool manual without composer

Related Topic