Monitoring Database structure updates

[Div By Zero]

Hi guys,

I've got a question for you, In big project we often have to modify the database structure with the evolving of the project, things like adding new fields, tables and optimizing indexes for each table. When the project is internal or for a single customer this is not a problem but with widely spread software we sell is very important for us to keep tracks of what has been modified.

Is there some tool to automatically monitor a given database, kepp track of what has been changed and produce sql to update the database structure from period A to period B ?

Thanks
Div

[longneck]

i don't know of any tools that do exactly what you want, but i may have a place for you to start: binary logging. the binary log would include any schema updates so you could use the mysqlbinlog to extract the DDL commands from the binary log.

see http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html and http://dev.mysql.com/doc/refman/5.0/en/binary-log.html