Do you know any good Database Schema Migration tool?

I'm currently writing a V2 of application, beyond the code change, some improvements have been done in the database as well as new data (columns/tables).

Now, I need to migrate my V1 data to my V2 application.

Things I need to do is map field in V1 database to field in V2 database, sets default for field that d开发者_开发知识库idn't exist in V1, transform DATA TYPE from V1 to V2 (like UNIX_TIMESTAMP to DATETIME).

It is a MySQL to MySQL data migration, so I don't care much about Database Conversion.

Any idea of any tools? Or Will I need to write it myself?

---

Set up a V1 system, do the migration by hand (I mean in SQL console), log your commands - the captured commands is cca. the migration script.

---

Try MySQL WorkBench. It's really good. A one stop solution for data modelling, server administration and SQL development.