Navicat

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Navicat
PremiumSoft Navicat Premium Logo.png
Original author(s) PremiumSoft CyberTech Ltd.
Developer(s) PremiumSoft CyberTech Ltd.
Initial release 2002
Operating system Cross-platform
Available in Multilingual
Type SQL database management and development system
License Proprietary / Shareware
Website www.navicat.com

Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL, MariaDB, 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.[1][2]

History[edit]

The initial version of Navicat was developed in 2001. The main target of the initial version was to simplify the management of MySQL installations. In 2008, Navicat for MySQL was the winner of the Hong Kong ICT 2008 Award of the Year, Best Business Grand Award and Best Business (Product) Gold Award.[3]

Supported platforms and languages[edit]

Navicat is a cross-platform tool and works on Microsoft Windows, Mac OS X and Linux platforms. Upon purchase, users are able to select a language for the software from seven available languages: English, French, Spanish, Japanese, Polish, Simplified Chinese and Traditional Chinese.

Development[edit]

Navicat for MySQL[edit]

Officially released in March 2002, the Windows 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. In November 2013, added the support of MariaDB.[4][5]

Navicat for PostgreSQL[edit]

PremiumSoft continued to expand their Navicat series by releasing Navicat for PostgreSQL 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.[6]

Navicat for Oracle[edit]

In August 2008 Navicat decided to further continue their product line and branch out into the Oracle 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.[7] The Oracle version of Navicat supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc.[8][9]

Navicat for SQLite[edit]

Navicat for SQLite 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.[10] In April 2010, Navicat Premium began including Navicat for SQLite starting from version 9 to expand the usability of Navicat Premium.[11]

Navicat Premium[edit]

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 connectivity 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. In November 2013, added the support of MariaDB.[11][12]

Navicat for SQL Server[edit]

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.[13]

Navicat Essentials[edit]

Navicat Essentials was officially 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.[14]

Navicat Data Modeler[edit]

Navicat Data Modeler Windows version was officially released in March 2012. Then, Mac OS X and Linux version were released in May 2012 and June 2012. This is a standalone product for developers to create data models for MySQL, SQL Server, Oracle, PostgreSQL and SQLite databases. Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc.

Navicat for MariaDB[edit]

MariaDB is currently the newest addition to the list of database Navicat supports. The new line of product, called Navicat for MariaDB, was released in November 2013 for the Windows, Mac OS X and Linux. It provides a native environment for MariaDB database management and supports the extra features like new storage engines, microsecond, virtual columns. Also at the release, the MariaDB version was included in both Navicat Premium and Navicat for MySQL.

Navicat iOS[edit]

In August 2014, PremiumSoft released a new product - Navicat iOS.[15] It is a database administration tool developed for iOS with features included object viewer & designer, query builder & editor, Navicat Cloud,[16] server monitor, etc. MySQL was supported in the first release.

Features[edit]

Navicat's features include:

  • visual query-builder
  • SSH and HTTP tunneling[2]
  • data and structure migration and synchronization[17]
  • import and export and backup of data[18]
  • report builder
  • task scheduling and wizards tool

There are differences in the features available across operating systems.[19]

Navicat also supports forks of MySQL such as Drizzle, OurDelta, and Percona

Version History[edit]

Version Platforms & Release dates Some notable features
MySQL PostgreSQL Oracle SQLite SQL Server MariaDB Premium
4.x
  • Windows: March 2002
  • Mac OS X: June 2003
  • Linux: No release
N/A N/A N/A N/A N/A N/A
  • Analyze, check, and repair tables
  • Visual user manager to administer users and privilege
  • Schedule backup file
  • Import and Export data from MS Excel and MS Access
5.x
  • Windows: January 2003
  • Mac OS X: January 2004
  • Linux: September 2004
N/A N/A N/A N/A N/A N/A
  • Back up database and tables to SQL scripts
  • Execute SQL script
  • Multiple SQL editors with syntax highlighted feature
6.x
  • Windows: April 2004
  • Mac OS X: November 2005
  • Linux: October 2005
  • Mac OS X: June 2006
N/A N/A N/A N/A N/A
  • Import data from ODBC
  • Connection to MySQL Server through SSH
  • Able to set schedule on profiles
7.x
  • Windows: November 2005
  • Mac OS X: November 2007
  • Windows: October 2005
  • Mac OS X: December 2007
  • Mac OS X: August 2008
N/A N/A N/A N/A
  • Data and structure Synchronization
  • Able to drag and drop tables
  • Create parameter queries
8.x
  • Windows: January 2008
  • Mac OS X: February 2009
  • Linux: January 2008
  • Windows: January 2008
  • Mac OS X: April 2009
  • Linux: August 2009
  • Windows: August 2008
  • Mac OS X: April 2009
  • Linux: August 2009
N/A N/A N/A
  • Windows: June 2009
  • Mac OS X: June 2009
  • Linux: August 2009
  • Virtual grouping
  • Server Monitor to change system variables
  • Allows form view
  • Able to preview SQL before execution
9.x
  • Windows: April 2010
  • Mac OS X: April 2010
  • Linux: June 2010
  • Windows: April 2010
  • Mac OS X: April 2010
  • Linux: June 2010
  • Windows: April 2010
  • Mac OS X: April 2010
  • Linux: June 2010
  • Windows: April 2010
  • Mac OS X: April 2010
  • Linux: June 2010
  • Windows: November 2010
  • Mac OS X: November 2010
  • Linux: N/A
N/A
  • Windows: April 2010
  • Mac OS X: April 2010
  • Linux: June 2010
  • History log viewer
  • Allows unicode character reports
  • Import and export connections
  • Word completion for SQL editors
10.0
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: September 2011
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: September 2011
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: September 2011
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: September 2011
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: N/A
N/A
  • Windows: September 2011
  • Mac OS X: September 2011
  • Linux: September 2011
  • Data Modeling Tool
  • ER Diagram view
  • Database wide search
  • Minify SQL
10.1
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: June 2012
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: June 2012
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: June 2012
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: June 2012
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: N/A
N/A
  • Windows: June 2012
  • Mac OS X: June 2012
  • Linux: June 2012
  • Multiple schemas in one model
  • Enhanced Import from Database Wizard
  • Enhanced Synchronize to Database Wizard
  • Align/Distribute Diagram Objects
  • Search table in Model Designer
11.0
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: April 2013
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: April 2013
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: April 2013
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: April 2013
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: N/A
  • Windows: November 2013
  • Mac OS X: November 2013
  • Linux: November 2013
  • Windows: April 2013
  • Mac OS X: April 2013
  • Linux: April 2013
  • New SSH Manager
  • Connection Tree Filter
  • Find and Replace data
  • Search Columns
  • Enhanced Import and Export Wizard
  • Native Windows and Mac 64-bit version
11.1
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: N/A
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Windows: August 2014
  • Mac OS X: August 2014
  • Linux: August 2014
  • Navicat Cloud
    • sync connections
    • sync queries
    • sync models
    • sync virtual groups

Navicat Community[edit]

Navicat Community provides a flexible environment for Navicat users to post questions, share experiences and solutions. It includes forum discussions, blog articles, tutorial videos and Wiki FAQ.

See also[edit]

References[edit]

  1. ^ http://onlamp.com/pub/a/onlamp/2004/12/22/navicat.html
  2. ^ a b http://www.lasplash.com/publish/Software_Reviews_and_News_130/navicat_mysql_gui_review.php
  3. ^ Winner of the HKICT Awards 2008: Best Business Grand Award selected winner of HKICT Award of the Year
  4. ^ Navicat for MySQL release notes
  5. ^ http://www.techmixer.com/navicat-mysql-mysql-database-management-tools-for-windows
  6. ^ Navicat for PostgreSQL release notes
  7. ^ Navicat for Oracle release notes
  8. ^ Navicat for Oracle overview
  9. ^ http://www.techmixer.com/navicat-for-oracle-windows-oracle-administration-tools/
  10. ^ Navicat for SQLite release notes
  11. ^ a b Navicat Premium release notes
  12. ^ http://www.techmixer.com/navicat-premium-cross-database-administrator-management-tool
  13. ^ Navicat for SQL server overview
  14. ^ Navicat Essentials feature
  15. ^ Navicat iOS
  16. ^ Navicat Cloud
  17. ^ http://www.webdotdev.com/nvd/content/view/438/
  18. ^ http://ted.onflash.org/2005/04/navicat-review-mysql-administration.php
  19. ^ Navicat Feature Matrix, for MySQL, MariaDB, PostegreSQL, Oracle, SQLite,SQL Server,Premium

External links[edit]