Navicat MySQL Database Editor
Tried and utilized some database administration tools for MySQL, but I felt like something was missing. Recently, started using Navicat for MySQL db management tool that provides what I required. It contains features that can be used to manage databases with a minimal amount of time.
Some of the key features of Navicat that I liked 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, we can connect to multiple databases like MySQL, Oracle and PostgreSQL simultaneously. There is a free Non-commercial Lite version version is available for download with limited features.
What editors are you using for your MySQL database management? For me Navicat is an excellent utility that performs database management/administration easier.
Comments
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.
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)
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.
I have also been using Navicat for about 2 years now. It has served me well and met my needs so far.
@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!
@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.
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.
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?)
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)
Not so far I have found new cool tool to work with mySQL - Valentina Studio. Its free edition can do things more than many commercial tools!! I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
My only beef with them is that they need nonetheless to introduce a version for the mack where i am spending a lot of of my time currently I actually had to use Navicat at my last job and extremely like SQLYog.
(Comments migrated from previous blog engine.)
