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.
1. Select source database or load an SQL script.
2. Select target database (you can also create it using builtin script editor)
3. Press Synchronize
Sync Database 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!
|