Sync Database MySQL Edition description
Sync Database - Instantly compare and synchronize your MySQL databases!
Sync Database is an easy to usef and useful solution to compare and sync MySQL databases. Structure differences are quickly determined and displayed, you can review and modify sync actions, as well as generated SQL script.
Sync Database synchronizes column, index, constraint information. Conversion between table types is supported as well.
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.
Here are some key features of "Sync Database MySQL Edition":
· 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
Limitations:
· 30 days trial