SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Monitoring Database structure updates

    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

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •