Welcome! Finally an easy solution to synchronize schema of mySQL databases! 1. Select source database or load an SQL script. 2. Select target database (you can also create it localy now) 3. Press Synchronize button. Synchronizes column, index, constraint information. Convert between table types. Supports transactions. Why use SyncDB? It is a common thing: a new application version is released. You have made some changes to database structure since last version. But now you have to code SQL difference script, then apply this to each client. Cumbersome, ha? With this small and efficient standalone app (all is contained in a single executable), you can be assured that sync will be done quickly and easily. FILE Open source script Opens a file open dialog to open an SQL file with commands to create a source (master) database. This is typically a file created by mysqldump program and contains a create/alter table statements as well as other DDL (data definition language) commands. TOOLS Options Fonts Enables you to alter user interface to your liking. Changes window lists changes made to your target database in order to make it synced with the source, and Script window contains actual script passed to database. Optimization Allow table type change Typically you define your tables to be MyISAM. If you want it to support transactions, you typically choose InnoDB type. SyncDB detects this change and here you can switch off commands to update table type. Drop obsolete columns If target table contains a field which does not exist in source table, it will by default be left present in target database. If you know you did not simply renamed a column (which would add of column of new name and drop original column with data in target table) you can enable the deletion here. General Synchronize to script only By default script commands are executed as SyncDB sweeps through databases and detects changes. If you want to be certain that you personally approve all changes to be posted to target database, you should turn this optionon, inspect generated script and run it if you are satisfied from the script window. Connect on startup Presents you with database chooser immediately at the program startup. Copy script to clipboard Automatically copies script to clipboard after operation. You typically use this option together with "Synchronize to script only" and then copy it to IDE of your choice. Use backticks Enables backticks (`) in generated script. Verbose log Logs also temporary changes to target database required to support some column or index changes. These commands are always added to script window, but are hidden from Changes window by default.