Sync Database MySQL Edition

   

An easy solution for MySQL structure synchronization tasks.                                  

How to quickly synchronize databases?
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

Why use Sync Database?
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.
 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!
Doing it the right way
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.

Script support
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.

Performance
The process is typically done in few seconds, and in only a few minutes on several hundred tables databases with many differences.

Safety
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 

                 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