Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.Advanced Code Completion with better suggestions.Open favorite tabs automatically when Navicat launches.Version 12 introduces a number of UI improvements over its predecessor, including: In recent editions, the makers of Navicat Enterprise added Cloud collaboration, which was a real game changer in the DBA field. I like the SQL Editor, Visual SQL Builder, and numerous import/export options. In the interest of full disclosure, I want to state before moving on that I personally use Navicat Enterprise. For this review, I’ll be approaching the product from my perspective as a MySQL developer who occasionally imports data from other database products. It’s a robust solution that is geared towards DBAs who would benefit from being able to connect to multiple databases simultaneously as well as migrate data between them in a seamless and consistent way.

While you’re deciding, I will be evaluating Navicat’s latest offering: Navicat Premium 12. Being a tool that you will no doubt be using a great deal, it’s vital that you carefully enumerate and weigh all of the features that would benefit you most. The Top 10 MySQL GUI Tools slideshow presented a few of the most popular DBMs. There are DBMs for specific databases and others who support many popular vendors. Sure, there is the occasional hold-out that hasn’t moved on since the days that DBAs used the command line to create, edit, and delete databases, but most would agree that a good DBM is the crown jewel of their arsenal. Ask a database administrator (DBA) to name their most cherished tool, and they’ll usually say it’s their database management (DBM) system.

. navicat for mysql