Akbarsait's Blog

Navicat MySQL Database Editor

I tried and used some database administration tools for MySQL but I feel like something was missing in its features. Recently I started using Navicat for MySQL database management which is really awesome and having many features which can be used to solve and manage your database with a very minimal amount of time.

Some of the key features of Navicat I have enjoyed using are transferring data between local and remote databases, visual editor, form viewer, schedule task, data and object dump features and many more. Also using Navicat you can connect to multiple databases like MySQL, Oracle and PostgreSQL simultaneously. There is a free Non-Commercial Navicat Lite version is available for download with some limited features. So what editors are you using for your MySQL databases management? For me Navicat is an excellent utility which makes my database management and administration easier.



I've been using SQLyog for MySQL for as long as I can remember. It servers me well and has helped me solve many a problem.

I'll take a look at Navicat as I'm always looking for new tools.
# Posted By Gary Funk | 12/30/09 9:00 PM
@Gary I’m sure you will like Navicat over SQLyog!
# Posted By Akbarsait | 12/30/09 11:01 PM
Yeah, I have been using Navicat on my Mac since 2006 and it is smooth.
# Posted By Nick Sophinos | 12/30/09 11:56 PM
I switched from navicat lite to http://www.sequelpro.com/ it's pretty good! lots of features not included in navicat and it is open source (and very "cute" ui)
# Posted By Raul Riera | 12/31/09 6:41 AM
I've been a happy Sequel Pro user as well. Altho recently Todd Sharp turned me on to mySQL Workbench (http://wb.mysql.com/). I've downloaded it, but haven't taken it for a test drive yet. Looking forward to doing so, as it sounds very impressive.
# Posted By Charlie Griefer | 12/31/09 4:14 PM
I have also been using Navicat for about 2 years now. It has served me well and met my needs so far.
# Posted By Jeff Pierson | 12/31/09 5:54 PM
@Nick Sophinos Thats really Awesome!

@Raul Riera Let me give it a try and thanks for pointing!

@Charlie Griefer Please blog about once you tried.

@Jeff Pierson Sounds Great!
# Posted By Akbarsait | 12/31/09 6:08 PM
@Charlie: I've been using MySQL Workbench since it was first in beta. It's really nice.

@Akbarsait: I tried Navicat and while it's nice, SQLyog has so many more features and is the most powerful MySQL tool I have found.
# Posted By Gary Funk | 12/31/09 9:01 PM
I actually had to use Navicat at my last job and really prefer SQLYog. My only beef with them is that they have yet to introduce a version for the Mac where I am spending more of my time these days.
# Posted By Rick Mason | 1/1/10 5:17 PM
I have just started to use Navicat, it looks real good so far; do you have any useful Navicat resources (espically on implementing many to many relationships using multiple foreign keys as a primary key?)
# Posted By Website Design Ltd | 1/27/10 8:52 AM
When it comes down to database editing and data editing (not running, backup etc) MySQL Workbench is a pile of crap. (Try edit a blob ("Text" rather) in table edit mode)

SQLyog is better.

Navicat is the betterest!
(If it supported MS-SQL I would use it at work)
# Posted By TheOddOne | 3/26/10 6:30 PM



About Me

ColdFusion/Web/Mobile Enthusiast and an avid Technology, Android & Xbox fan who works as Consultant/Project Manager in Chennai. more
Akbarsait's Blog RSS Feed Twitter Google Plus Facebook Twitter Facebook


  ColdFusion 9,10 & CFBuilder Tutorials    MySql Backup and FTP



  


Archives