Hi everyone,

I would find a tool (stable) where one can compare two MySQL databases with each other, logging the structure changes and data, for use to upgrade the other table.

The reason, my applications always supports an upgrade function, but I grew tired of keeping manual logs of all the changes from the previous version to the new version. This included structure and data. I would then add an upgrade script that upgrades the old database of the previously released to the most recent one.

As one with experience in this regard could imagine, it takes up precious time designing the upgrade mysql scripting, altering tables and data.

Is there an application available that could generate the changes ready for mysql?

Regards,
Titan

    Search in google for "mysql database compare". This will reveal at least one pearl script that will do what you want. Searching php.net for 'mysql diff' returned http://vancouver.php.net/node/470 and a program called Navicat.

      wilku wrote:

      Search in google for "mysql database compare". This will reveal at least one pearl script that will do what you want. Searching php.net for 'mysql diff' returned http://vancouver.php.net/node/470 and a program called Navicat.

      Mmm... my search terms was wrong when I searched. Thanks for the heads up...

        Write a Reply...