I am learning the process of migration from Magento 1 to Magento 2. I have installed Magento 22.214.171.124 (with sample data) and Magento 2.2.6 (no sample data) on one server. When I run Data Migration Tool, it fails with many "Source fields are not mapped" errors. I have attached a screenshot.
The reason it fails is that it doesn't know how to migrate several tables. For example, there is a "move" record in
map.xml, saying that
sales_flat_creditmemo corresponds to
sales_creditmemo. But the first table has a field
base_customer_balance_amount and the second table doesn't have it. And there is no record in default config that would handle this field.
It seems Data Migration Tool is even not capable of migrating a basic configuration. It means either sample data for Magento 1.9 messes up database schema, or I am doing something wrong.