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.
Yes, you can use the data-migration-tool for this, and I'd recommend to do so over any other methods: it will do the necessary field value conversions where needed.
We were in a similar position as you: we imported product data (catalog, products) at an earlier point in time, then built the shop's design and functionalities and now will do a final data migration run for the customers, quotes, orders, logs and similar stuff.
In the config.xml, comment out the substeps you do not want to run again. in my case, I have the following disabled:
- settings: everything
data: eav step, url rewrite step, configurable prices step, tier price step, post processing step
in map.xml, I made sure to ignore all tables that I do not want the data to be migrated for.
Be sure to include the necessary
<ignore><document>{tablename}</document></ignore>
in both sections (<source> and <destination> (maybe called <target> in older versions)).
Be sure to test the migration on a copy of your db's (both magento 1.x and magento 2.x) as it can be quite destructive. It took me a few days and tries to get the mappings adjusted to our needs, but now the migration runs through without a hick.
I was not able to get the delta migration properly running with the above modifications, but in most cases, you'll only want to migrate the data just once before switching the new shop live.
If your 1.x shop has a fair amount of data, the migration process will take quite a while tho. be sure to run the migration in a screen shell session or similar to avoid data loss due to disconnects.
Best Answer
Uberthemes makes a magento 2 module that handles this pretty well. You'll need your credentials for the databases on both ends. The github page is pretty straight forward.
Check it out:
https://github.com/ubertheme/module-ubdatamigration/blob/master/README.md