How to transfer data from one database to another with a different structure?

Question

MySQL

The site was rewritten, the structure of the database also underwent changes, now you need to transfer all the data from the old database to the new one.
Are there any convenient facilities for Symfony 2.7 and Doctrine? Or the old fashioned way, by hand?

Answer 1

Use dbForge Studio for MySQL
, it has a tool for comparing two databases, it can also make a patch, rolling it onto one database, it will make it identical to the second

Answer 2

And how do you imagine it in general? What should such a tool do? Analyze the old structure, then the new one, then get into your head and find out what exactly you reflected in these changes and what relates to what and prepare an SQL file for you based on the analysis of your brain?)
The easiest way is to write the script yourself)