Do you know any good Database Schema Migration tool?

Question

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 didn'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?

Answer 1

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.