Magento 2 Migration Tool – Verify Successful Migration from 1.9 to 2.0 CE

magento-1.9magento2magento2-migration-tool

mage2\vendor\magento\data-migration-tool\etc

mage2\vendor\magento\data-migration-tool\etc\ce-to-ce

mage2\vendor\magento\data-migration-tool\etc\ce-to-ce\1.9.2.2

mage2\vendor\magento\data-migration-tool\etc\ce-to-ce\1.9.2.2\config.xml

    <?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
    <source version="1.9.2.2">
        <database host="localhost" name="magento9" user="root"/>
    </source>
    <destination version="2.0.2">
        <database host="localhost" name="mage2" user="root"/>
    </destination>
    <steps mode="settings">
        <step title="Settings Step">
            <integrity>Migration\Step\Settings\Integrity</integrity>
            <data>Migration\Step\Settings\Data</data>
        </step>
        <step title="Stores Step">
            <integrity>Migration\Step\Stores\Integrity</integrity>
            <data>Migration\Step\Stores\Data</data>
            <volume>Migration\Step\Stores\Volume</volume>
        </step>
    </steps>
    <steps mode="data">
        <step title="EAV Step">
            <integrity>Migration\Step\Eav\Integrity</integrity>
            <data>Migration\Step\Eav\Data</data>
            <volume>Migration\Step\Eav\Volume</volume>
        </step>
        <step title="Customer Attributes Step">
            <integrity>Migration\Step\Customer\Integrity</integrity>
            <data>Migration\Step\Customer\Data</data>
            <volume>Migration\Step\Customer\Volume</volume>
        </step>
        <step title="Map Step">
            <integrity>Migration\Step\Map\Integrity</integrity>
            <data>Migration\Step\Map\Data</data>
            <volume>Migration\Step\Map\Volume</volume>
        </step>
        <step title="Url Rewrite Step">
            <integrity>Migration\Step\UrlRewrite\Version191to2000</integrity>
            <data>Migration\Step\UrlRewrite\Version191to2000</data>
            <volume>Migration\Step\UrlRewrite\Version191to2000</volume>
        </step>
        <step title="Log Step">
            <integrity>Migration\Step\Log\Integrity</integrity>
            <data>Migration\Step\Log\Data</data>
            <volume>Migration\Step\Log\Volume</volume>
        </step>
        <step title="Ratings Step">
            <integrity>Migration\Step\Ratings\Integrity</integrity>
            <data>Migration\Step\Ratings\Data</data>
            <volume>Migration\Step\Ratings\Volume</volume>
        </step>
        <step title="ConfigurablePrices step">
            <integrity>Migration\Step\ConfigurablePrices\Integrity</integrity>
            <data>Migration\Step\ConfigurablePrices\Data</data>
            <volume>Migration\Step\ConfigurablePrices\Volume</volume>
        </step>
        <step title="OrderGrids Step">
            <integrity>Migration\Step\OrderGrids\Integrity</integrity>
            <data>Migration\Step\OrderGrids\Data</data>
            <volume>Migration\Step\OrderGrids\Volume</volume>
        </step>
        <step title="Tier Price Step">
            <integrity>Migration\Step\TierPrice\Integrity</integrity>
            <data>Migration\Step\TierPrice\Data</data>
            <volume>Migration\Step\TierPrice\Volume</volume>
        </step>
        <step title="SalesIncrement Step">
            <integrity>Migration\Step\SalesIncrement\Integrity</integrity>
            <data>Migration\Step\SalesIncrement\Data</data>
            <volume>Migration\Step\SalesIncrement\Volume</volume>
        </step>
    </steps>
    <options>
        <crypt>
            <key>1bc968bd50b96ee18388feaed3bc1f1d</key>
        </crypt>

        <map_file>etc/ce-to-ce/1.9.2.2/map.xml</map_file>
        <eav_map_file>etc/ce-to-ce/1.9.2.2/map-eav.xml</eav_map_file>
        <eav_document_groups_file>etc/ce-to-ce/1.9.2.2/eav-document-groups.xml</eav_document_groups_file>
        <eav_attribute_groups_file>etc/ce-to-ce/1.9.2.2/eav-attribute-groups.xml</eav_attribute_groups_file>
        <log_map_file>etc/ce-to-ce/1.9.2.2/map-log.xml</log_map_file>
        <log_document_groups_file>etc/ce-to-ce/1.9.2.2/log-document-groups.xml</log_document_groups_file>
        <settings_map_file>etc/ce-to-ce/1.9.2.2/settings.xml</settings_map_file>
        <customer_map_file>etc/ce-to-ce/1.9.2.2/map-customer.xml</customer_map_file>
        <customer_document_groups_file>etc/ce-to-ce/1.9.2.2/customer-document-groups.xml</customer_document_groups_file>
        <customer_attribute_groups_file>etc/ce-to-ce/1.9.2.2/customer-attribute-groups.xml</customer_attribute_groups_file>
        <order_grids_document_groups_file>etc/ce-to-ce/1.9.2.2/order-grids-document-groups.xml</order_grids_document_groups_file>
        <class_map>etc/ce-to-ce/1.9.2.2/class-map.xml</class_map>
        <!--
        In case bulk_size=0 it will be auto-detected for every document.
        -->
        <bulk_size>0</bulk_size>
        <!--
        Set direct_document_copy = 1 for better performance.
        NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
        and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
         -->
        <direct_document_copy>0</direct_document_copy>
        <source_prefix />
        <dest_prefix />
        <auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
        <log_file>migration.log</log_file>
        <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
        <upgrade_customer_password_hash>1</upgrade_customer_password_hash>
    </options>
</config>

settings.xml is copied from path mage2\vendor\magento\data-migration-tool\etc\ce-to-ce

Added settings.xml.dist and map.xml.dist at location mage2\vendor\magento\data-migration-tool\etc

In CMD prompt I am executing below commands for settings and data migration respectively

php bin/magento migrate:settings vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.2/config.xml

php bin/magento migrate:data vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.2/config.xml

and it says Migration Compelted.

After flushing cache and reindexing, I do not see any changes in my Mage 2.0 installation. Its the same.

To use the mapping files:

1. Rename or copy them to remove the .dist extension.
2. Edit them using the schema located in <your Magento 2 install   dir>/vendor/magento/data-migration-tool/etc.
3. Then change config.xml in <options> node with the new name of the file.

How can I verify if settings and data are migrated successfully ?
Have I made any mistake in Configuring the migration OR
Configuration and mapping files ?

Reference URL – http://devdocs.magento.com/guides/v2.0/migration/migration-tool-configure.html

Best Answer

try below solutions, with file name,

magento2/vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.1/map.xml

you have to keep below tag inside <source><document_rules>

<ignore>   
      <field>customer_eav_attribute.is_used_for_customer_segment</field>
</ignore>

Related Solutions

Magento – Magento2 Data migration getting stuck at Step Customer Attribute

Try disabling the customer hash in the config.xml file.

<upgrade_customer_password_hash>0</upgrade_customer_password_hash>

Magento Migration – M1 to M2 CE-to-CE Data Migration Issues

Your errors are self explanatory. Did you read the migration documentation?

I'll try to guide you in the right direction:

As you can see, your old M1 Database contains a lot of extra tables or fields for custom modules. For example:

ebizmarts_mailchimppro
interaktingslider_slide
mobicommerce
twlogin

to mention a few.

Now, from the documentation:

Some Magento 1 entities (in most cases, coming from extensions) 
do not exist in the Magento 2 database.

This message appears because the Data Migration Tool runs internal 
tests to verify that tables and fields are consistent between 
source (Magento 1) and destination (Magento 2) databases.

So you either install the M2 versions of the modules, or you tell the migration tool to ignore all the unmapped documents or fields by editing your map.xml file. Read the documentation as to where to configure which map file is used for your magento 1 version.

Then ignore all the fields and tables, for example:

<ignore>
  <document>addtocart_device</document>
</ignore>

and

<ignore>
   <field>catalogrule.attribute_to_select</field>
</ignore>

If tables or fields are called differently in M2, you can rename tables or move fields by using eg:

<rename>
  <document>sales_flat_quote_item</document>
  <to>quote_item</to>
</rename>

and

<move>
  <field>catalog_category_entity_varchar.entity_id</field>
  <to>catalog_category_entity_varchar.row_id</to>
</move>

respectively.

--- edit as per comment:

Example error:

[2017-09-06 14:00:06][ERROR]: Source fields are not mapped. Document: sales_flat_order. Fields: onestepcheckout_customercomment,orderfromplatform

Fix:

<ignore>
   <field>sales_flat_order.onestepcheckout_customercomment</field>
</ignore>
<ignore>
   <field>sales_flat_order.orderfromplatform</field>
</ignore>

Best Answer

Related Solutions

Magento – Magento2 Data migration getting stuck at Step Customer Attribute

Magento Migration – M1 to M2 CE-to-CE Data Migration Issues

Related Topic