Advanced MySQL comparison and synchronization
Performance
The process is typically done in few seconds, and in only a few minutes on several hundred tables databases with many differences.
Safety
The reference database is not touched at all. Target database data is left intact. Only work database structure is changed, so you need not worry about losing or corrupting your data. Of course, if your reference database column is shorter than your work database column, you might trim your work data.
SQL Dump Script support
You can even compare and synchronize target database to reference SQL scripts defining reference database structure. So you don't need to have physical connection to reference server. Make a database dump (only of structure, so the file stays small) and take only one file with you.
Features at a glance
- Full support for MySQL 5
- Command-line support
- Synchronization of columns, indexes, constraints, views, stored procedures and functions
- Built-in difference viewer
- Built-in color-coded SQL script editor
- Synchronization between different servers supported
- Saving of settings and generated SQL scripts to files
- Detection of changed table types
April 23, 2007
Version 3.2 released
See Version History for more info.