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.

Comments

Popular posts from this blog

Flixify Video Streaming Platform

How To Make Sitemap in Blogger

How To Connect To Server Using FTP