Sync Database is an easy solution to synchronize the schema of MySQL databases.
A software developer constantly tweaks application and database design. A database structure at your development server at one time has to be applied to production server(s). You can do it by hand remembering changes you made. Or not? Another case: When a new version of your software is is released, you have to apply changes to your customers' existing database so new code can work for them, too. If you have a clients with one version and release a new one, you have to run a script to the underlying database. If you have 5 different versions spread, you need 5 different scripts or difference scripts from version 1 to 2, from 2 to 3 etc.
Using this efficient application, you can quickly see the differences between any two databases. You can also generate SQL script needed to change target database structure so it is equal to reference database.
You can even compare and synchronize target database to reference SQL script 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.
The process is typically done in few seconds, and in only a few minutes on several hundred tables databases with many differences. Target database data is left intact. Only database structure is changed, so you need not worry of lost data.
Features:
Easy and quick automated process
Synchronization of columns, indices, constraints
Detection of changed table types
Support for transactions
Built-in color-coded SQL script editor
Synchronization between different servers supported
Easy Synchronize Process:
1. Select reference database or load an SQL script. 2. Select target database (you can also create it localy now). 3. Press Analyze button. 4. You can now inspect database differences and optionally delete some of generated sync actions. 5. Press Execute Sync Script! button.
Screenshots:
 Connecting to source database
 Connecting to target database
 Analyzing...
 Visual difference view and editable generated list of actions required to get databases in sync
Generated SQL sync script |