如何将MySQL数据库移动到新结构？！ 任何工具？ [关闭]

Question

I need to move a old database with an old structure to a new one.

Both Databases are MySQL Databases (InnoDB). The Information is basically the same but has been moved to different tables and stuff like that.

What I'm searching now is a tool which helps me to move the data to the new structure. Something like a data mapping tool which generates the php code or something like that for me.

Is there something like that or do you know a better way to do so?

Thanks in advance

Answer 1

Look into ETL (Extract Transform Load) tools. Popular (and free) ones are Talend Open Studio and the Pentaho Suite.

But don't expect miracles.

The migration of a complex database schema is not a simple task and you won't find any easy point and click tools. You will need to put a lot of thinking into it.