1. Stepan Koltsov
  2. mysql-diff

Wiki

Clone wiki

mysql-diff / Related

Tools with SQL parser

Perl MySQL-Diff

http://search.cpan.org/dist/MySQL-Diff/

We used it before our mysql-diff. It is buggy.

apgdiff

http://apgdiff.sourceforge.net/

Does not extract information from the live database.

Commercial tools

MySQL Workbench

http://dev.mysql.com/doc/workbench/en/wb-database-diff-report.html

Other tools

Without SQL parser.

dbdeploy

http://dbdeploy.com/software/features/

LiquiBase

http://en.wikipedia.org/wiki/LiquiBase

Database structure and all structure updates must be described as XML file.

DdlUtils

http://db.apache.org/ddlutils/

BatchAccess

http://www.rsdn.ru/article/files/progs/BatchAccess.xml

Alter MS Access databases with SQL scripts.

Updated