O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data and structure synchronization

If you have multiple instances of your database across different servers, for example, one for development, one for testing, and one other for production, it can be challenging that, for consistency, sometimes making a change in one (most likely in development) requires applying the exact same changes to the others. We as humans often make the mistake of neglecting one or more changes on all of the servers and end up with unexpected errors after deployment.

Navicat comes to the rescue in this area as well, with its structure and data synchronization wizards accessible from the Tools menu.

Another situation where the synchronization tools could be useful is in cases where a previously performed data transfer operation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required