Navicat
Encyclopedia
Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL
, Oracle
, SQLite
, PostgreSQL
and Microsoft SQL Server
. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.
student in six months. The main target of the initial version was to simpify the management of MySQL installations.
In 2008, Navicat for MySQL was the winner of the Hong Kong ICT 2008 Best Business Grand Award and Best Business (Product) Gold Award.
, Mac OS X
and Linux
platforms. Upon purchase, users are able to select a language for the software from eight available languages: English, French, German, Japanese, Korean, Polish, Simplified Chinese and Traditional Chinese.
version of Navicat for MySQL
became the first product offered to the public by PremiumSoft. Subsequently, the company released two additional versions of Navicat for MySQL on the Mac OS X
and Linux
operating system in June and October 2003 respectively.
for Windows in October 2005 and then for MAC OS X in June 2006. The Linux version of Navicat for PostgreSQL would not be released until 3 years later in August 2009.
community, creating Navicat for Oracle for Windows and Mac. In August of the following year they followed up with a version for the Linux Platform. The Oracle version of Navicat supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc.
was released for Windows and Mac OS X simultaneously in April 2009, and the Linux version soon followed two months later in June of the same year.
In April 2010, Navicat Premium began including Navicat for SQLite starting from version 9 to expand the usability of Navicat Premium.
is currently the newest addition to the list of database Navicat supports. The new line of product, called Navicat for SQL Server, was released in November 2010 for the Windows platform and Mac OS X. Also at the release, the SQL server version was included in the Premium version of Navicat.
In January 2011, support for SQL Azure was added.
There are differences in the features available across operating systems.
Navicat also supports forks of MySQL such as Drizzle
, MariaDB
, OurDelta, and Percona
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
, Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
, SQLite
SQLite
SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
, PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
and Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.
History
The initial version of Navicat was developed in 2001 by a Hong Kong University of Science and TechnologyHong Kong University of Science and Technology
The Hong Kong University of Science and Technology is a public university located in Hong Kong. Established in 1991 under Hong Kong Law Chapter 1141 , it is one of the nine universities in Hong Kong.Professor Tony F. Chan is the president of HKUST...
student in six months. The main target of the initial version was to simpify the management of MySQL installations.
In 2008, Navicat for MySQL was the winner of the Hong Kong ICT 2008 Best Business Grand Award and Best Business (Product) Gold Award.
Supported platforms and languages
Navicat is a cross-platform tool and works on Microsoft WindowsMicrosoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
, Mac OS X
Mac OS X
Mac OS X is a series of Unix-based operating systems and graphical user interfaces developed, marketed, and sold by Apple Inc. Since 2002, has been included with all new Macintosh computer systems...
and Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
platforms. Upon purchase, users are able to select a language for the software from eight available languages: English, French, German, Japanese, Korean, Polish, Simplified Chinese and Traditional Chinese.
Navicat for MySQL
Officially released in March 2002, the WindowsMicrosoft Windows
Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
version of Navicat for MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
became the first product offered to the public by PremiumSoft. Subsequently, the company released two additional versions of Navicat for MySQL on the Mac OS X
Mac OS X
Mac OS X is a series of Unix-based operating systems and graphical user interfaces developed, marketed, and sold by Apple Inc. Since 2002, has been included with all new Macintosh computer systems...
and Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
operating system in June and October 2003 respectively.
Navicat for PostgreSQL
PremiumSoft continued to expand their Navicat series by releasing Navicat for PostgreSQLPostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
for Windows in October 2005 and then for MAC OS X in June 2006. The Linux version of Navicat for PostgreSQL would not be released until 3 years later in August 2009.
Navicat for Oracle
In August 2008 Navicat decided to further continue their product line and branch out into the OracleOracle
In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination....
community, creating Navicat for Oracle for Windows and Mac. In August of the following year they followed up with a version for the Linux Platform. The Oracle version of Navicat supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc.
Navicat for SQLite
Navicat for SQLiteSQLite
SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard...
was released for Windows and Mac OS X simultaneously in April 2009, and the Linux version soon followed two months later in June of the same year.
In April 2010, Navicat Premium began including Navicat for SQLite starting from version 9 to expand the usability of Navicat Premium.
Navicat Premium
In 2009, PremiumSoft released Navicat Premium, a series of Navicat software that combines all previous Navicat versions into a single version and can connect to different database types including MySQL, Oracle, and PostgreSQL simultaneously, allowing users to do data migration between cross databases. Navicat Premium version also supports cross-platform administration, serving Windows, Mac OS X and Linux. In April 2010, version 9 of Navicat Premium was released, which added the connectivitity of SQLite database to Navicat Premium, allowing Navicat Premium to connect to MySQL, Oracle, Postgresql and SQLite in a single application. In November 2010, support for Microsoft SQL Server was added. In January 2011, SQL Azure was included.Navicat for SQL Server
Microsoft SQL ServerMicrosoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
is currently the newest addition to the list of database Navicat supports. The new line of product, called Navicat for SQL Server, was released in November 2010 for the Windows platform and Mac OS X. Also at the release, the SQL server version was included in the Premium version of Navicat.
In January 2011, support for SQL Azure was added.
Navicat Essentials
Navicat Essentials was official released in November 2011. This is a simple Navicat version for commercial use. The Essentials editions of Navicat lack several features found in the Standard/Enterprise editions, including form view, record filtering, visual query building, data modeling and options for import, export and backup of data, etc.Features
Some of its features include:- Visual query builder
- SSH and HTTP tunneling
- Data and structure migration and synchronization
- Import and export and backup of data
- Report builder
- Task scheduling and wizards tool
There are differences in the features available across operating systems.
Navicat also supports forks of MySQL such as Drizzle
Drizzle (database server)
Drizzle is a free software/open source relational database management system that was forked from version 6.0 of the MySQL DBMS.Like MySQL, Drizzle has a client/server architecture and uses SQL as its primary command language...
, MariaDB
MariaDB
MariaDB is a community-developed branch of the MySQL database, the impetus being the community maintenance of its free status under GPL, as opposed to any uncertainty of MySQL license status under its current ownership by Oracle....
, OurDelta, and Percona
Revision History
Below is a table of different versions and releases of Navicat.| Version | Platforms Operating system An operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system... & Release dates |
Some notable features | |||||
|---|---|---|---|---|---|---|---|
| MySQL | PostgreSQL | Oracle | SQLite | SQL Server | Premium | ||
| 4.x |
|
N/A | N/A | N/A | N/A | N/A |
|
| 5.x |
|
N/A | N/A | N/A | N/A | N/A |
|
| 6.x |
|
|
N/A | N/A | N/A | N/A |
|
| 7.x |
|
|
|
N/A | N/A | N/A |
|
| 8.x |
|
|
|
N/A | N/A |
|
|
| 9.x |
|
|
|
|
|
|
|
| 10.0 |
|
|
|
|
|
|
|