Moving Magento Catalog

The best route to migrate a catalog from one Magento store to another can be accomplished with the following procedure

• Take a complete database backup of the target Magento Store
• Now separately backup the following tables on the target Magento Store
  • All tables beginning with catalog
  • eav_attribute
  • eav_attribute_group
  • eav_attribute_label
  • eav_attribute_option
  • eav_attribute_option_value
  • eav_attribute_set
  • eav_entity_attribute
  • eav_form_element
  • eav_form_fieldset
  • eav_form_fieldset_label
  • eav_form_type
  • eav_form_type_entity
  • customer_eav_attribute
  • customer_form_attribute
• Now transfer the above tables from the source Magento Store to the target Magento Store
• Verify orders in target store can be opened
• Verify products can be edited
• Verify products on front-end
• Procedures Complete!