Overall: It is an excellent tool that allows me to design all aspects of a MySQL DB's. That of course I could also do with the free MySQL GUI-tools or phpMyAdmin.
The real values of Navicat are:
- editing of tables in an Excel type fashion
- import/export from/to many function
- migration of DB's from one server to another
Problems solved ?
We had several large Excel sheets which we wanted to transfer to a web-based database information system. Designing the DB was easy - and the front-end we build with PHPmagic. But we needed to get all the data into the DB and clean it. Also needed a tool for the DBA's to do things you cannot do thru the web-interface.
Documentation ? I don't really need any - its is all so intuitive
Wishes ? just one: an easy way to copy a value into multiple/all cells in column to a value (like in Excel)
By Proenen, Hanns, GE (Capital Solutions GmbH & Co.KG)
Navicat provided a quick and easy means of importing many different spreadsheets into database tables and an easy way to update those tables. Even after weeks of having a standard process of managing the database we utilize Navicat's import mechanism to handle unique data updates coming from our customer. Without this ability we would be weeks behind schedule.
By James Hoover, HP(Hewlett-Packard Development Company, L.P.)
1) Problem solved: The main problem Navicat is solving for me is creating the queries in a fast.
The query builder helps tremendously with that - and I haven’t seen any other tool that helps me create my queries for MySql.
2) Product functionality: As described above, I use the query builder quite a lot to create my views.
i. PROBLEM SOLVED
We needed to easily administer and update tables with CSV files on a mysql database hosted on a remote machine. This needed to be achieved on a regular basis, by users uncomfortable with the command line. We tried most other mysql GUIs on OS X but found them too unstable or limited in features.
The database is critical for reporting needs and day to day problem solving. However, it was developed in a “quick and dirty” way (outside on the company IS&T process) and so we were free to choose how we deployed and administered it.
ii. PRODUCT FUNCTIONALITY The clear and powerful GUI was leagues ahead of other solutions. Of particular importance to this choosing this solution was the strong CSV upload and export tools. It also proved really useful to be able to store queries and share them between users. The query builder was a big plus too.
Stability, ease of use, common interface
We’re really happy with Navicat and only wish that we’d chosen the product sooner.
By Matt Fenby Taylor, SonyBMG Music Entertainment Ltd.
I got navicat, because I was building a database to manage wide range of data for the earthquake research project SAFOD.
I had about 10 different excel spreadsheets that I was tracking various bits of data, which was confusing enough, but I need to get the information out to more people. So I decided to convert to MySQL database, and Navicat really helped easily get my excel data into mysql, and Navicat makes it easy to maintain using a GUI, rather than the line commands, or tedium of phpMyAdmin for multiple edits.
I am sure Navicat will have more to offer, as my database matures. I can't comment on the documentation, because I've been able to figure out the few things I need to do just from the menus and icons on screen.
Navicat is fabulous, fast, easy to use. It makes working with databases fun.
It's much better than TOAD. "I would like to suggest Navicat to consider adding a more complete "Help" information. Include tips and tricks within the application, like (e.g.) CuteFTP does. I know it has been extended to PostgreSQL. It would be nice to see it extended to other databases, e.g., Pervasive/Btrieve, MS Access, DB2, dBASE and Filemaker.
My favourite features of Navicat are Backup, import/export, basic database functionality, including browsing tables, connections management, toolbar, subdivision of functions, user management, queries, performance. I'd like to see being able to search backwards in the text of query results. Haven't used Scheduling or Stored Procedures yet.
The Manual is okay. Support materials could do with deeper detail, especially since Navicat is limited in the number of databases it supports. Perhaps there might be some way of integrating Navicat support and help with information about MySQL and PostgreSQL?
By Jan Theodore Galkowski of MIT (Massachusetts Institute of Technology)
We use your product Navicat for our reporting. We have heterogenous types of data base. Therefore we need a product that can import and export various data formats. Navicat is strong in that function and it has a good query handling. Especially the query builder helps me to save time.
Navicat has a good user interface and it has perfect multitasking usability.
It helps very much for our department to generate new reports.
Navicat is approaching the functionality of MS Enterprise Manager.
Using Navicat, it is essentially a breeze to manage MySQL. In fact, recently we upgraded our server software to 10.3.3 -- this upgrade also upgraded MySQL to the latest version. In the process, the data in the databases was corrupted. Fortunately, before upgrading to software, we used Navicat to backup up our databases. With the backups and Navicats, we were able to restore all of our databases back to their original condition.
Navicat is easy to use because the menus and tools bars are very clearly label and designed. We have never had a problem with the software crashing or corrupting data.
A GUI interface that provides complete functionality for configuring and using MySQL. What might take hours with the command line, Navicat can accomplish in seconds.
Perhaps Navicats greatest strength is it's ability to manage users and permissions and import/export data.
The software was easy to download and install. Even with a university purchase order, we were able to order and install the software within 24 hours (counting the time for our internal procedures).
The online documentation is clearly written and easy to access. In fact, our main Navicat user commented, "It is so easy to use, you don't even need documentation."
Thanks for delivering and excellent product. It is going to save us tons of time and time is money!
Navicat is very important for us to manage our MySQL databases. It is quite
easy to use and has very powerful features as, for instance, the query
The features we use most are the backup and queries, also in relation with
the scheduler. A nice-to-have feature would be a mailer function where, for
instance, a result of a query could be sent to a specific user.
"There are two major reasons for my purchasing Navicat. First, I am using it to transfer a database from MS Access to MySQL, and Navicat makes the transfer between software engines extremely simple, better than the other options I explored.
Second, the interface for dealing with the database is straightforward, easy to use, and powerful. It is convenient to use to begin to implement SQL code, for example. "
We have recently begun using MySQL to support web based inquiries. We were looking for an efficient way to move data from our test server to our production server without having to write and test a lot of scripts.
Navicat does an excellent job and as an added bonus, we can use the export function to convert data into other formats for specialized use.
The XML conversion was particularly impressive. We have not implemented the backup function yet but preliminary examination suggests that it " will also be very useful."
By Donald J. Varney, Systems Developer III
State of Vermont - Department of Banking, Insurance, Securities & Health Care Administration
"I use Navicat to help with entry, and quick retrieval of records for Personnel Tracking for the Marine Corps through a quick database I set up with Mysql. There are approximately 2300 rows, and approx 123 columns for each row of data, It is used daily, I am currently trying to convince the office the benefits of using the MySQL/Navicat combination over other implementations. "
I enjoy your product very much, I purchased it, and Navicat increase productivity 1000 fold.
By Jonathan Mark Petrush , United States Marine Corps
We have tried many different software to manage our MySQL databases in the past, however only PremiumSoft Navicat came out on top. Once I download it as a trial I knew I had to purchase it for our company. The time it saves us managing our databases is unavailable. The backup features and how simple it is to use cannot be compared. I recommend PremiumSoft Navicat to everyone I know. Keep up the great work guys!!!
By Orlando Piedrahita, System Engineer, World Fuel Services Corporation (NYSE:INT)
PremiumSoft Navicat has solved several problems for me. My biggest problem was database backup. With Navicat automated backup is extremely easy. I just scheduled a backup job to run every day using Navicat and the problem was solved.
Table design and alterations are a snap with Navicat . New tables can be constructed in a fraction of the time it used to take. The export feature of Navicat allow me to export data in a form that can be used on Palm Pilots by my employees. User management is very easy with Navicat . Adding, deleting and setting privileges is easily done with a few clicks of the mouse.
Customer support for Navicat is very good. My email questions were quickly and accurately answered.
I have tried many other fine programs, but PremiumSoft Navicat is by far the best. Ease of use and the list of features make it my choice for MySQL administration.
By Jeff Tucker, Director of Engineering, Emmis Communications (NASDAQ: EMMS)
I wanted to let you know how pleased we are with your software. I am the Website Manager for a State Government Agency. I recently converted all of our web application data to the open source data server, MySQL. We needed the capacity of MySQL but we also needed a User Interface that our staff could readily use without the expense of training. PremiumSoft Navicat gives us that.
Most of our data is in Microsoft Access or MS SQL Server. With Navicat importing and exporting data from and to those formats is very easy and requires virtually no additional training. Moving to new technology is often intimidating to people but once I demonstrated Navicat to our staff they were pleasantly surprised.
I personally use much more of your products functionality such as Scheduled Back-ups, User Management, and general database creation and management but in my opinion the import/export functionality alone more than justifies the purchase of Navicat . Navicat truly makes it easier to administer mySQL than any other product I have tried.
Our group needed a low-cost SQL server solution off-site UCSF. MySQL was the primary candidate. However, me being a statistician and not at all familiar with MySQL or the SQL server idea, I needed to learn quickly and efficiently to get our server on-line. Since the MySQL administrator was difficult to work with, I looked for a front-end that would make my job easier. PremiumSoft's Navicat did the job beyond my expectations.
Usually, my test of whether a product is good is the minimal use of the documentation. My test of an excellent product is not having to look at the documentation at all. Navicat is an excellent product and I have yet to look at the documentation!
Navicat 's strengths are (obviously) its ease of setup and use. I've dealt with software since my junior year in high school (1981) and know a good product when I see one.
By Jesse A. Canchola, Principal Statistician Director, Data Analytic & Survey Services
"We have numerous databases running on many different platforms. We are currently migrating many of our SQL Server, and MS Access databases from a Windows environment to a Linux/MySQL environment. Administration of the MySQL databases was slow when I had to do it all from a command line."
"I recently downloaded a trial of Navicat and within an hour knew it was a product I couldn't do without. I purchased a full copy, have used it almost daily, and have recommended it to many others in my field. It is by far the best product of its kind on the market. And the price is much lower than I would have expected for such a robust feature rich product."
"I use your product every day and am still amazed at how great it is and how much time it saves me."
By Jeff Austin, Division of Biological Sciences, Office of the Dean
"Your product saved us a lot of time and solved my problem of importing and exporting the data to the tables and even creating Tables, Databases, and Queries. Now I do not have to worry about how to backup the Databases -its just one click now-".
"It is so easy and simple for the Unix Administrator to connect to the local or remote Database and manage the users with full security. And I would like to thank your technical support staffs. They answered all my question in a short period of time."
By Firas Najjar, Web Application Developer at College of Engineering
BASIC USAGE - "At the American Geological Institute, we currently use Navicat to maintain databases on the activities of academic geoscience departments worldwide in an effort to evaluate the health of our discipline. With such a variety of tasks and several MySQL servers, we were looking for a management solution that allowed us to quickly deal with multiple servers and rapidly extract custom queries, as well as prototype data model changes in our existing and developing applications."
OUR EXPERIENCE - "Navicat solved a couple key problems for which we purchased it. First, we were looking for an efficient front-end to manage our 5 MySQL servers, particularly for rapid database and table creation as well as account management. We have used a number of the other MySQL admin products available, but Studio's approach was efficient and intuitive, especially in user management. Also, the ability for us to move seamlessly between our different MySQL servers is a dream, as each is charged with specific projects, but often we are juggling requests and needs in a rapid-fire sequence - so the ability to move between servers instantly is awesome. A couple things which we have grown to love about the product is the visual query builder and the multitude of import and export options. With the ongoing problems using myODBC and Access, having an Access-like visual query builder has enabled us to prototype complex queries fairly easily, and perhaps even more important, has represented a great learning tool for staff to become comfortable with the constructs of SQL and how databases work. By showing our non-technical staff how queries are built and then the equivalent SQL, they have actually been able to better assist in the spec'ing of new data needs and providing better formulated custom query requests -- which has saved us time and money."
PRODUCT DELIVERABLES - "From the standpoint of a physical product, Navicat was the first product that our company allowed us to purchase for download. The process was painless and we believed improved the economics of the solution. To date we have had no need for documentation as Navicat is rather intuitive, and has generally stuck with well established process approaches. The support has been extremely good, with update notices emailed directly with links to download and active the updates. So far, from a customer service perspective, the use and maintenance of Navicat has been one of the most pleasant products we currently use."
By Christopher M. Keane, Ph.D., Director, Comm., Development, and Tech.
Conestoga Valley School District
Before, I was at a loss as to how to access our Mysql information stored on our webserver. We had a Penn State intern that developed a website for us last summer to document Right To Know information. It was an information site that quizzed employees on sections of information and when completed, they would submit to the website their name as having completed the documentation.
When the intern set up the site, she used Mysql because it was easier for her to work with than MS SQL for web development. I knew she did this and assumed that I could view the information with a tool in Mysql. Unfortunately for me, that is not how it works. In order to extract the table info in a similar manner that SQL uses, I stumbled on your product - Navicat. I had the demo version up in running in minutes.
It did everything I needed it to do in a simplier way than by using text type tools. I purchased two copies so that we can use it with other Mysql databases that we want to deploy. The purchase was simple, and the product is now up and running. Since we need to develop additional databases, I am sure it will help us make that management much easier. Thanks.
By Doug Stoner- Manager of Computer Services, Conestoga Valley School District