Right tool for tracking DB structure changes

Question

Right now i have a PHP project and i track all changes in code by SVN. I would also like to track changes made in database structure.

Which is the right tool to use ?

Answer 1

I usually solve this with scripted database dumps, containing the table definitions and all other things you might be interested in. This will even handle your data itself if your DB is not too big.

For a more systematic approach, you could have a look at Liquibase. I haven't tried it myself so can't comment on the practical usability, but it seems like it could be a very valuable tool for DB versioning.