Migration of CiviCRM is terrible
I’m not sure how others migrate CiviCRM but the experience is a mess from a lack of quality documentation to the actual process. I was migrating a install and followed existing documentation and simply could not get the SQL to import via PHPMyAdmin it kept throwing errors and I consider myself to be expert level with managing databases. I even brought in a tech from my hosting provider and they escalated to a senior tech and couldn’t make it happen.
I’d highly encourage some work to improve documentation and also to look into improving the migration process. After hours of failed attempts I had to simply create reports for all data and do a clean install and manually do data entry which as you can imagine isn’t an ideal scenario. I’d suggest some sort of export and import function where data can be saved to a csv and imported that way if the sql issues which others seem to run into can’t be resolved.