General Electric
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) |
Hewlett-Packard - Case Study
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.
See the full case study, click here.
By James Hoover, HP(Hewlett-Packard
Development Company, L.P.) |
Yahoo! Inc
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.
3) Strengths: query builder, query builder, query builder.
4) Documentation: I rarely (actually never) have used the documentation since the
product is pretty much self-explanatory.
By Ed Garcia, Yahoo! (NASDAQ: YHOO) |
|
JPMorgan Chase & Co.
Very professional product. Easy to use. Nice GUI.
We use Navicat to produce custom reports based on complex queries.
By Jeff
Jeff Gellner, CISSP
JPMorgan Chase & Co. |
SonyBMG
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.
iii. STRENGTHS
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 Lt
|
|
Stanford
University
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.
By Charley Weiland, Stanford University |
|
MIT
(Massachusetts Institute of Technology)
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) |
|
Intel
Corporation
These are the features
that we like :
- It allows us to transfer
file between two servers
- It allows us to synchronize between two databases
in a single and bidirectional directions
- It allows us to build queries faster with query
builder
- It allows us import and export databases into
different file formats
It has a good online visual
demo. The help file is also well organized and
easy to follow.
By Mark Horn,
Intel Corporation (Nasdaq:INTC) |
|
TOSHIBA
Europe GmbH
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.
Thank you for that nice tool.
By Karl Hogerl, Internet
& Database Service Engineer , TOSHIBA
Europe GmbH |
|
Porsche
Leipzig GmbH
I worked since 2005 with this
database tool. As interface to our MySQL severs
I developed with Navicat many queries. The tables
are partial very big (more than 50 Million records).
With my favourite tool Navicat
I create the queries fast and effective and with
nightly schedules I get the query results on early
morning.
Last week I generated a support
ticket, because some of my schedules doesn't
work. But your support worked quick and professional
and now everything is alright.
By Volker Plank, Porsche
Leipzig GmbH |
|
Harvard
University
I live in a cross platform world.
We need to be able to offer every access to MySQL
database for Mac as well as PC users. Navicat
is the only program I have seen that works this
well on the Mac.
Able to export and import easily. Very easy to
use. Lightening fast. Scheduling, back-ups, Queries
are all very easy to use. This does a lot more
than what I expected.
Didn't really need the documentation. Navicat
was so well designed and user-friendly that I
just started using it.
By Scott Lozier, Administrative
Coordinator , Office
for the Arts at Harvard |
|
Alcatel
One tool solution for Designing,
Managing and Automating MySQL. Transferring data
from one server to other is very convenient. Backup
and restoration DB in 1 easy step.
Navicat integrates managing MySQL
database in a very user friendly interface. Updating
without a UI from search table results. The database
conversion from older formats to MySQL is seemless.
By Sandeep.Bishnoi, Alcatel |
|
KPMG
Advisory
I really like the new GUI in
the new eddition -Navicat 2004.
The Speed of Navicat 2004 is very fast and its
Interface is very nice. Stability has also been
strengthened.
By Karsten Torp Rasmussen,
Senior Consultant, KPMG
Advisory |
|
Washington
State University Student Publications
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!
By Dave Garcia, Washington
State University Student Publications |
|
Goodyear
Luxembourg Tires SA
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
builder.
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.
By Gilbert Schroeder, Goodyear
Luxembourg Tires SA. |
|
Columbia
University
"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. "
By Dr Tim Walsh , Research
Foundation For Mental Hygiene - Columbia University |
|
State
of Vermont - Department of Banking, Insurance,
Securities & Health Care Administration
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 |
|
United
States Marine Corps (www.usmc.mil)
"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 bennifits 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 |
|
Oxford
University, Nuffield Orthopaedic Centre
Navicat allows the building
of complex queries, and also management and backup
of the database, from a remote windows environment.
Navicat is relative ease of use, and flexibility.
By Dr Richie Gill, Oxford
University |
|
World
Fuel Services Corporation (NYSE : INT)
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
can not 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) |
|
Emmis
Communications (NASDAQ: EMMS)
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.
Overall Impression
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) |
|
North
Carolina Department of Agriculture & Consumer
Services
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 truely makes it easier to administer mySQL
than any other product I have tried.
By Matthew Ryan, NCDA&CS
Website Manager
|
|
University
of California at San Francisco
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 |
|
Alsco,
Inc. - the first supplier of textile services
worldwide
"At the Alsco,
Inc., We have used several products to administer
our MySQL databases used in our I.T. Department.
Most have come up "wanting" for add'l
features until we found PremiumSoft's product.".
"These are the strengths
of Navicat --"
- Easy to manage multiple
connections
- Access to MySQL databases
across the WAN is very quick and efficient
compared to other products
- Designing and updating table structures
is much easier than comparable products (additional
fields can be inserted and deleted without
redoing the entire table structure)
- Provides an "easy
to use" import and export wizard (for
Excel this is great)
- User administration interface is excellent
- Reporting tool looks
promising (have used it minimally so far)"
By Larry Tomsic, Director
- Information Technology
|
|
University
of California, Davis
"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 |
|
Florida
State University
"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 |
|
American
Geological Institute
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 evalute
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 |
|
|
Navicat is already being used
by Toshiba
Europe GmbH., Vodafone, Boeing, hp, Porsche,
Ford Motor, General Electric, Sony Music, Intel,
Kodak, FedEx, Sharp, KPMG
Advisory, Sony Ericsson, Hitachi, Alcatel,
Siemens AG, Yahoo!, Imation, Lexmark, Cisco Systems, AOL, British
Telecom (BT), RSA Security, Avis (Europe), The Gillette Company,U.S.
Department of Energy, Harris Bank, Central Carolina Bank, Goodyear
Tires SA, Harvard
University, Oxford
University, NASA Space Flight Center, MIT, Stanford University,
Columbia
University, World
Fuel Services Corporation (NYSE : INT), Reuters America Inc.
...

|




|