I have always migrated from a Magento 1 server database copy that is local and restored on MySQL 5.7 (on the same database host as my Magento 2 migrate database).
I would usually use
<direct_document_copy>1</direct_document_copy> in config.xml, but now I want to do a migration test from a live Magento 1 website - so I need to do this:
My question though : this live Magento 1 database is running on MySQL 5.6x, and I am aware that Magento 2.2+ runs on MySQL 5.7. I need to test
migrate:delta (delta migration) eventually, the databases I always ran tests on was offline (so no database triggers will have any effect).
How would I do this migration when my source database version and destination database versions aren't the same?
Can I just run the migration on the live site? I can't upgrade to MySQL 5.7 on the production server - because of the Magento 1 database.