Queation about m2-migration:delta-update-changelog and populated tables

[ioweb-gr]

I've wanted to try out the command for this however I have a question about which tables it populates. In the Magento 1 database I see lots more _cl tables than what is processed by the command.

For example the command processed these tables

Command result

Processing Magento 1 table cataloginventory_stock_item / Magento 2 table cataloginventory_stock_item
1 entities were found for cataloginventory_stock_item
Processing Magento 1 table catalog_compare_item / Magento 2 table catalog_compare_item
22 entities were found for catalog_compare_item
Processing Magento 1 table customer_address_entity / Magento 2 table customer_address_entity
6 entities were found for customer_address_entity
Processing Magento 1 table customer_address_entity_datetime / Magento 2 table customer_address_entity_datetime
No new entities found for customer_address_entity_datetime
Processing Magento 1 table customer_address_entity_decimal / Magento 2 table customer_address_entity_decimal
No new entities found for customer_address_entity_decimal
Processing Magento 1 table customer_address_entity_int / Magento 2 table customer_address_entity_int
57864 entities were found for customer_address_entity_int
Processing Magento 1 table customer_address_entity_text / Magento 2 table customer_address_entity_text
51637 entities were found for customer_address_entity_text
Processing Magento 1 table customer_address_entity_varchar / Magento 2 table customer_address_entity_varchar
549767 entities were found for customer_address_entity_varchar
Processing Magento 1 table customer_entity / Magento 2 table customer_entity
3 entities were found for customer_entity
Processing Magento 1 table customer_entity_datetime / Magento 2 table customer_entity_datetime
795 entities were found for customer_entity_datetime
Processing Magento 1 table customer_entity_decimal / Magento 2 table customer_entity_decimal
No new entities found for customer_entity_decimal
Processing Magento 1 table customer_entity_int / Magento 2 table customer_entity_int
75385 entities were found for customer_entity_int
Processing Magento 1 table customer_entity_text / Magento 2 table customer_entity_text
No new entities found for customer_entity_text
Processing Magento 1 table customer_entity_varchar / Magento 2 table customer_entity_varchar
224974 entities were found for customer_entity_varchar
Processing Magento 1 table downloadable_link_purchased / Magento 2 table downloadable_link_purchased
No new entities found for downloadable_link_purchased
Processing Magento 1 table downloadable_link_purchased_item / Magento 2 table downloadable_link_purchased_item
No new entities found for downloadable_link_purchased_item
Processing Magento 1 table eav_entity_store / Magento 2 table eav_entity_store
No new entities found for eav_entity_store
Processing Magento 1 table gift_message / Magento 2 table gift_message
No new entities found for gift_message
Processing Magento 1 table log_visitor / Magento 2 table customer_visitor
67996 entities were found for log_visitor
Processing Magento 1 table newsletter_subscriber / Magento 2 table newsletter_subscriber
No new entities found for newsletter_subscriber
Processing Magento 1 table rating_option_vote / Magento 2 table rating_option_vote
No new entities found for rating_option_vote
Processing Magento 1 table rating_option_vote_aggregated / Magento 2 table rating_option_vote_aggregated
No new entities found for rating_option_vote_aggregated
Processing Magento 1 table report_compared_product_index / Magento 2 table report_compared_product_index
24 entities were found for report_compared_product_index
Processing Magento 1 table report_event / Magento 2 table report_event
36657 entities were found for report_event
Processing Magento 1 table report_viewed_product_index / Magento 2 table report_viewed_product_index
31053 entities were found for report_viewed_product_index
Processing Magento 1 table review / Magento 2 table review
No new entities found for review
Processing Magento 1 table review_detail / Magento 2 table review_detail
No new entities found for review_detail
Processing Magento 1 table review_entity_summary / Magento 2 table review_entity_summary
No new entities found for review_entity_summary
Processing Magento 1 table review_store / Magento 2 table review_store
No new entities found for review_store
Processing Magento 1 table sales_flat_creditmemo / Magento 2 table sales_creditmemo
1 entities were found for sales_flat_creditmemo
Processing Magento 1 table sales_flat_creditmemo_grid / Magento 2 table sales_creditmemo_grid
1 entities were found for sales_flat_creditmemo_grid
Processing Magento 1 table sales_flat_creditmemo_item / Magento 2 table sales_creditmemo_item
No new entities found for sales_flat_creditmemo_item
Processing Magento 1 table sales_flat_invoice / Magento 2 table sales_invoice
26 entities were found for sales_flat_invoice
Processing Magento 1 table sales_flat_invoice_grid / Magento 2 table sales_invoice_grid
26 entities were found for sales_flat_invoice_grid
Processing Magento 1 table sales_flat_invoice_item / Magento 2 table sales_invoice_item
No new entities found for sales_flat_invoice_item
Processing Magento 1 table sales_flat_order / Magento 2 table sales_order
6 entities were found for sales_flat_order
Processing Magento 1 table sales_flat_order_address / Magento 2 table sales_order_address
10 entities were found for sales_flat_order_address
Processing Magento 1 table sales_flat_order_grid / Magento 2 table sales_order_grid
6 entities were found for sales_flat_order_grid
Processing Magento 1 table sales_flat_order_item / Magento 2 table sales_order_item
23 entities were found for sales_flat_order_item
Processing Magento 1 table sales_flat_order_payment / Magento 2 table sales_order_payment
6 entities were found for sales_flat_order_payment
Processing Magento 1 table sales_flat_order_status_history / Magento 2 table sales_order_status_history
5 entities were found for sales_flat_order_status_history
Processing Magento 1 table sales_flat_quote / Magento 2 table quote
63965 entities were found for sales_flat_quote
Processing Magento 1 table sales_flat_quote_address / Magento 2 table quote_address
132463 entities were found for sales_flat_quote_address
Processing Magento 1 table sales_flat_quote_address_item / Magento 2 table quote_address_item
No new entities found for sales_flat_quote_address_item
Processing Magento 1 table sales_flat_quote_item / Magento 2 table quote_item
160241 entities were found for sales_flat_quote_item
Processing Magento 1 table sales_flat_quote_item_option / Magento 2 table quote_item_option
447870 entities were found for sales_flat_quote_item_option
Processing Magento 1 table sales_flat_quote_payment / Magento 2 table quote_payment
57573 entities were found for sales_flat_quote_payment
Processing Magento 1 table sales_flat_quote_shipping_rate / Magento 2 table quote_shipping_rate
112827 entities were found for sales_flat_quote_shipping_rate
Processing Magento 1 table sales_flat_shipment / Magento 2 table sales_shipment
28 entities were found for sales_flat_shipment
Processing Magento 1 table sales_flat_shipment_grid / Magento 2 table sales_shipment_grid
28 entities were found for sales_flat_shipment_grid
Processing Magento 1 table sales_flat_shipment_item / Magento 2 table sales_shipment_item
No new entities found for sales_flat_shipment_item
Processing Magento 1 table sales_flat_shipment_track / Magento 2 table sales_shipment_track
No new entities found for sales_flat_shipment_track
Processing Magento 1 table sales_order_tax / Magento 2 table sales_order_tax
5 entities were found for sales_order_tax
Processing Magento 1 table sales_order_tax_item / Magento 2 table sales_order_tax_item
14 entities were found for sales_order_tax_item
Processing Magento 1 table wishlist / Magento 2 table wishlist
No new entities found for wishlist
Processing Magento 1 table wishlist_item / Magento 2 table wishlist_item
No new entities found for wishlist_item
Processing Magento 1 table wishlist_item_option / Magento 2 table wishlist_item_option
No new entities found for wishlist_item_option

But I also see these tables

m2_cl_catalog_category_entity
m2_cl_catalog_category_entity_datetime
m2_cl_catalog_category_entity_decimal
m2_cl_catalog_category_entity_int
m2_cl_catalog_category_entity_text
m2_cl_catalog_category_entity_varchar
m2_cl_catalog_category_product
m2_cl_catalog_compare_item
m2_cl_catalog_product_bundle_option
m2_cl_catalog_product_bundle_option_value
m2_cl_catalog_product_bundle_selection
m2_cl_catalog_product_bundle_selection_price
m2_cl_catalog_product_entity
m2_cl_catalog_product_entity_datetime
m2_cl_catalog_product_entity_decimal
m2_cl_catalog_product_entity_group_price
m2_cl_catalog_product_entity_int
m2_cl_catalog_product_entity_media_gallery
m2_cl_catalog_product_entity_media_gallery_value
m2_cl_catalog_product_entity_text
m2_cl_catalog_product_entity_tier_price
m2_cl_catalog_product_entity_varchar
m2_cl_catalog_product_link
m2_cl_catalog_product_link_attribute
m2_cl_catalog_product_link_attribute_decimal
m2_cl_catalog_product_link_attribute_int
m2_cl_catalog_product_link_attribute_varchar
m2_cl_catalog_product_option
m2_cl_catalog_product_option_price
m2_cl_catalog_product_option_title
m2_cl_catalog_product_option_type_price
m2_cl_catalog_product_option_type_title
m2_cl_catalog_product_option_type_value
m2_cl_catalog_product_relation
m2_cl_catalog_product_super_attribute
m2_cl_catalog_product_super_attribute_label
m2_cl_catalog_product_super_attribute_pricing
m2_cl_catalog_product_super_link
m2_cl_catalog_product_website

Those aren't processed?

[peterjaap]

@ioweb-gr it's been a loooooong time since I built this and I haven't used it since, so it might be Magento added more options to the migration tool that weren't there when I built this.