How To Synchronize Database Using Navicat

Navicat is a database management tool provided by Premium Soft. I like Navicat so much, it is cool, easy to use and really fast in performance, i mean if i compare with like for example Workbench, it is outperformed it. And Navicat has lot of cool features, one that i really like much is the tool which we can synchronize the database from our local development computer to our server production, when you don't need to manually like for example changing or adding your database structure.

There are 2 different synchronizing tools, the one is for synchronizing the structure, second is for synchronizing the data.

1. To synchronize your database, the first thing you need to do is connect both your localhost and your server.
2. Go to Tools menu and select either Data synchronization or Structure synchronization
3. On Source section choose your most updated database, and on target choose the database that you want to update

4. Click next, then compare, wait until it finish the process, the deploy, review the SQL script, or you can just click Execute
5. You can do the reverse, from server to local, just change the source and target

It's really a handy tool, definitely save my time a lot. But there's still performance issue when you do comparing, it's an expensive process connecting to remote MySQL.


Popular posts from this blog

ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password

Spring Kafka - how to use ReplyingKafkaTemplate send and reply synchronously

How To Create Spring Boot Project Using Netbeans

How To Connect SSH Using PEM Certificate On Windows

How to Add MySQL JDBC Driver To Wildfly