peterjaap / magerun-addons

Addon modules for n98-magerun
187 stars 41 forks source link

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

Open ioweb-gr opened 3 years ago

ioweb-gr commented 3 years ago

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 commented 3 years ago

@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.