Is it possible to copy all customer related data migrate to another magento 2 database?

Question

I want to know how I can copy only customer related data

to another Magento 2 database

If it is possible then what are the tables that I can copy to the second DB

Magento ver 2.2.6

Answer 1

As I understand your question, you want to copy the basic information of customers (with their addresses) from one Magento installation to another one.

To do this, you don't need to dig into the database tables.

Magento 2 provides a default feature of exporting and importing customers' data.

Just go to System ⇒ Export ⇒ Export Settings to see the export options. Here you can export customers main file (containing the basic info) and customer addresses. Check the checkboxes which fields you don't want in the exported file.

Similarly, go to System ⇒ Import ⇒ Import Settings to see the import options.

For more detailed tutorial, visit:

https://bsscommerce.com/blog/how-to-import-and-export-customer-data-in-magento-2/

or

https://www.mageplaza.com/kb/magento-2-export-import-customers.html

Answer 2

All Customer Data Including Logs In This Table :

customer_address_entity;
customer_address_entity_datetime;
customer_address_entity_decimal;
customer_address_entity_int;
customer_address_entity_text;
customer_address_entity_varchar;
customer_entity;
customer_entity_datetime;
customer_entity_decimal;
customer_entity_int;
customer_entity_text;
customer_entity_varchar;