Sync Database is an easy solution to synchronize schema of mySQL databases. When you alter database, add or change columns, indices or constraints, sync is done in an quick and painless process and enables you to change the structure of your older database to its newest version while preserving its data.
· Select source database or load an SQL script.
· Select target database (you can also create it using builtin script editor)
· Press Synchronize synchronizes column, index, constraint information.
Conversion between table types is supported, as well as transactions. Typical Sync Database use: A software developer constantly tweaks application and database design. When a new version 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 to have 5 different scripts or apply a difference scripts from version 1 to 2, from 2 to 3 etc. Why not going the simpler way? Using this efficient standalone app (all is contained in a single executable), you can be assured that sync will be done quickly and easily. No need to remember your versions. You provide the latest (reference) SQL script or database, choose your target, and run. The process is done in seconds!
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
Requirements:
· MySQL 3.x
Limitations:
· 30 days trial
· Nag screen
What's New in This Release: [ read full changelog ]
· Complete redesign of user interface
· Added quoting of field names when specifying field reordering
· Fixed error parsing key names larger than 50 characters