Navicat Review

I do a good amount of work in MySQL so that I need a good database admin tool.  I come from a Microsoft Enterprise Manager/Management Studio background so much of this review compares to that as a benchmark.

The Good

  • Import/Export Data feature rocks.  Much easier to use then DTS for simple imports & exports & supports multiple formats (db, dbf, txt, html, xls, wk1, wq1, xml, mdb, ODBC)
  • Dump as SQL.  Will write out your table to .sql file with the full inserts.  Microsoft so needs this.
  • Maintain Tables.  Easily able to
  • Backups.  Straight forward step by step.
  • Saved Queries.  Navicat saves then within the application at the database level not a sql file, this makes finding queries much faster.
  • Scheduled Job.  Again straight forward step by step
  • Manage Users.  They make it as simple as MySQL can be (which isn’t that simple sense you have to create a user multiple times to have access from localhost and from anywhere)
  • Data Transfers.  Their version of DTS, not as robust but gets the job done.

The Bad

  • Query Windows.  This is my biggest complaint of Navicat and almost a show stopper for me. Tabbed windows are great BUT having multiple tabs within tabs causes my eye to lose focus of which tab I need.  Not good for quick tabbing, I have to think before clicking which slows me down. I much prefer how Management Studio has tabs for queries but shows results at the bottom of that window.

 

  • Query Builder.  I do most of my SQL by hand so this doesn’t effect me to much but Navicat’s query builder uses the dreaded Grave `instead of the Quote ‘.  So if you use their query builder to get a sql statement started, maintaining it could be a nightmare.
  • Designer. Seems clunky and implemented as a second thought.  Big improvements here.

Overall Navicat is the most feature rich MySQL tool on the market (I’ve tried ~4 so far). Pricing is at $139, well within reason. Besides a reworking of the query window, Navicat is a finely tuned.  2 TechToolBlog thumbs up.

Tim

A .NET, PHP, Marketing Guru authority, at least I hope I am. Reach me at tboland@gmail.com

12 thoughts on “Navicat Review

  1. Bob Hussey says:

    Did you try SQLyog?

    I tried many other tools but finally settled with SQLyog.

  2. Tim says:

    Yes, SQLyog has features I like over Navicat (their query windows are nicer), but their import/export wasn’t as robust.

  3. Freeware and Shareware Software Downloads…

    I couldn’t understand some parts of this article, but it sounds interesting…

  4. Web Hosting Providers Directory…

    Sorry, it just sounds like a crazy idea for me :)

  5. Martin Digg says:

    hey guys, Tim is absolutely rite. i have been using sqlyog as gui for mysql & am pretty much impressed with its feature & flexibility. Its effective and efficient backup and restoring is outstanding they have improved their quality much better than before. just try it tim and all !!!

  6. SQLyog has features I like over Navicat (their query windows are nicer), but their import/export wasn’t as robust.

  7. malick heuvel says:

    navicat can be bad when migrating data from one db (for example in mysql) to another db (for example mssql) and writing query statements in the query editor of navicat which make use of concats to add insert into …..values + select from mysql table..

    Navicat can spontaniously chance the text into (BLOB) output which can only be only viewed by clicking on the MEMO button this is bad for export BLOB data is converted to hexadecimal text when exporting

  8. mark robinson says:

    I use a product Valentina http://www.valentina-db.com/valentina-studio-overview, very easy to use and free. I’m very satisfied.

  9. Key Pro M8 says:

    Import/Export Data feature rocks. Much easier to use then DTS for simple imports & exports & supports multiple formats (db, dbf, txt, html, xls, wk1, wq1, xml, mdb, ODBC)

  10. I love in excess of Navicat free store cards (their question glass windows usually are nicer), nevertheless his or her import/export wasn’t as sturdy.

  11. I’m thinking about trying Navicat, so lucky to find your review. Thank you for sharing! It’s very helpful for me. instagram technology

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>