MySQL database synchronization tools

MySQL Workbench Manual :: 9.5.1 Database Synchronization
July 19, 2022 – 09:39 am
MySQL :: MySQL Workbench Manual :: 9.5.1 Database Synchronization

Synchronize data between models, databases, and SQL files. These three types can be the target (destination), source, or both. You can also select/deselect individual objects and modify their direction during the synchronization. For example, synchronize tables from a model to your database, other tables from your database to your model, and skip a few tables, all during the same synchronization process.


Be aware that backward incompatible MySQL syntax changes are introduced over time, so for this reason it is important to set the Default Target MySQL Version modeling preference according to your needs. For example, exporting results from a MySQL 5.7 target might yield invalid syntax when executed against MySQL 5.1. See also Section 3.2.4, “Modeling Preferences”.

To start, select from the navigation menu. Alternatively, select Synchronize Model to open the same wizard that defaults to a model. A Model or EER diagram must be selected for these synchronization options to be present under the navigation menu.

Figure 9.50 Start the Synchronization Wizard


Because MySQL databases correspond to directories within the data directory, you must consider case sensitivity for database, table, and trigger names, which follow the case sensitivity rules of the underlying file system for your operating system. Synchronizing models with objects that differ in case may lead to MySQL Workbench producing a DROP statement for that object, before recreating it as lowercase. For more information, see Identifier Case Sensitivity

Workarounds include using a consistent convention, where the most portable code uses lower case database and table names. Or a temporary workaround is to delete the DROP SCHEMA IF EXISTS line from the generated query.

MySQL Workbench enables control over objects to synchronize, and the direction of synchronization for each object. Synchronization options include:

  • Specify all or specific tables and objects to synchronize
  • Synchronize both the model and live database, or only update one or the other (unidirectional or bidirectional)
  • Optionally update from or to an SQL script file
  • Instead of executing the synchronization, you may generate an ALTER Script File to later perform the appropriate updates
  • Fine-tune how the synchronization will be performed by choosing the direction of each individual object, or configuring particular objects to be ignored
bonds international patterned outdoor tiles the christmas chronicles coworking south london pubs with outdoor seating near me how to create business page on facebook philadelphia coworking space disney tops worldwide outdoor bar garden bar ideas lloyds international bank cheap coworking spaces near me why is international business important? what is a small business stylish trainers mens reach out worldwide how to make business plans what is business intelligence analyst christmas hampers 2022 international daughters day yorkshire building society jobs communication definition when will business travel resume aran knit is stylish but rebellious christmas background images international charles schwab outdoor games christmas coloring pages what people think of you is none of your business autistic society what is a communication plan dpd international what is coworking what is a joint venture business vertical communication stylish showy crossword clue trouble around one boys communication ugly christmas jumper stylish office chair uk almost christmas how to start an online coaching business wandsworth coworking space community benefit society outdoor store outdoor bars manchester christmas lights near me
Related Posts