Magento – Magento 2 Data Migration Tool ignore unknown documents

magento2magento2-migration-tool

I am going to migrate data with the Magento 2 Data Migration Tool. Because the Magento 1 installation I want to migrate has lots of custom tables that come from extensions, I get tons of errors when migrating data. I would be fine to only migrate the standard magento tables.

Do I have to add an ignore statement to the map.xml file for every document I want to ignore? This is a lot of work for me, so my question is, is there any possibility to tell the migration tool to just ignore unknown documents?

My workaround would be to figure out some handy search/replace pattern to generate the xml from the error message I get from the data migration tool.

Best Answer

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.

Related Solutions

Tables Updated in Data Migration Tool Map Step – Magento 2

Map step is responsible for transferring most of data from Magento 1 to Magento 2. This step reads instructions from map.xml file (located in etc dir). The file describes differences between data structures of source (Magento 1) and destination (Magento 2). In case Magento 1 contains tables or fields that belong to some extension that does not exist in Magento 2, then these entities can be placed here to ignore them by Map Step. Otherwise it will show an error message.

This step transfers all attributes (e.g. product, customer, RMA) from Magento 1 to Magento 2. It uses map-eav.xml file that contains rules similar to the ones in map.xml file for specific cases of processing data.

Some of the tables that are processed in the step:

eav_attribute
eav_attribute_group
eav_attribute_set
eav_entity_attribute
catalog_eav_attribute
customer_eav_attribute
eav_entity_type

In addition to the Map Step, there are other steps in the config.xml file which migrate data with major format and structure changes, including:

Url Rewrite Step
OrderGrids Step
EAV Step

Unlike the Map Step, these steps scan a predefined list of tables instead of all tables.

Reference: https://devdocs.magento.com/guides/v2.3/migration/migration-tool-internal-spec.html

I hope this will help

Magento – Migration from magento 1.9.2 to magento 2.3

Install Data Migration Tool

1) Check your Magento 2 version :- sudo php bin/magento --version

2) Install Data Migration Tool from repo.magento.com :-

composer config repositories.magento composer https://repo.magento.com                                   
composer require magento/data-migration-tool:<magento_version>

3) Configure Magento 2 Data Migration Tool :-

    1 The above file will contain configuration and scripts for migrating from Magento 1 Open Source platform to Magento 2 Open          Source platform.
         <your Magento 2 install dir>/vendor/magento/data-migration-tool/etc/opensource-to-opensource

    2 The above file will contain configuration and scripts for migrating from Magento 1 Open Source platform to Magento 2 Commerce.
         <your Magento 2 install dir>/vendor/magento/data-migration-tool/etc/opensource-to-commerce

    3 The above file will contain configuration and scripts for migrating from Magento 1 Commerce to Magento 2 Commerce.
         <your Magento 2 install dir>/vendor/magento/data-migration-tool/etc/commerce-to-commerce

4) Configuring the migration :-

    1 Change to the following directory :-
      <your Magento 2 install dir>/vendor/magento/data-migration-tool/etc/<migration edition>/<ce or version>

    2 Rename config.xml.dist to config.xml 
      cp config.xml.dist config.xml

    3 Open config.xml in a text editor.

    4 Specify the following at minimum:

            <database host="localhost" name="Magento1-DB-name" user="DB-username" password="DB-password"/>

            </source>

            <destination>

            <database host="localhost" name="Magento2-DB-name" user="DB-username" password="DB-password"/>

            </destination>

            <options>

            <crypt_key>Magento1-Encrypted-Key</crypt_key>

            </options>

5) Migrate settings :-

        php bin/magento migrate:settings --reset vendor/magento/data-migration-tool/etc/<edition-to-edition>/<version>/config.xml

6) Migrate Data :-

        php bin/magento migrate:data --auto vendor/magento/data-migration-tool/etc/<edition-to-edition>/<version>/config.xml

7) Migrate Delta :-

        php bin/magento migrate:delta --auto vendor/magento/data-migration-tool/etc/<edition-to-edition>/<version>/config.xml

Best Answer

Related Solutions

Tables Updated in Data Migration Tool Map Step – Magento 2

Magento – Migration from magento 1.9.2 to magento 2.3

Related Topic