We have two enviroments Staging and Production, for Magento 2.3.5. At the moment these two enviroments have different database structure, meaning that we can't just dump the entire DB and restore it to the other enviroment. We need to merge Orders, products,customers from one DB to another. I have thought of the following 3 options.
- Use Magento 2 default import / export function to export orders, products and customers then import to another enviroment
- dump all relavant mysql tables for orders, products and customers and restore them to another enviroment
- write an custom module, something like using Magento's resrouce model, to transfer orders, products and customers to another enviroment
which one of the above option would you suggest? are there any other better way to do it?