Unanswered: generating diff files between two databases
I'm developing an application depending on a mysql database and since it's pretty early in the development process I usually alter the database schema and data between releases. I dont want my users to have to re-install everything for every new release, so I want to be able to generate a diff between the current and the new version.
I've been looking at tools like mysqldiff(.org), MySQL:DIFF (in perl) and datadiff (also in perl), but none of them can produce both schema and data diffs which makes the job pretty much manual anyway.
Is there any tools out there that creates a complete diff? Do you guys have any better solutions for handling the differences? It's a 22-table database so doing it completely manual is a pain.