Navicat - Features

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, MariaDB, OurDelta, and Percona

Version Platforms & Release dates Some notable features
MySQL PostgreSQL Oracle SQLite SQL Server Premium
4.x
  • Windows: March 2002
  • Mac OS X: June 2003
  • Linux: No release
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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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: 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

Read more about this topic:  Navicat

Famous quotes containing the word features:

    However much we may differ in the choice of the measures which should guide the administration of the government, there can be but little doubt in the minds of those who are really friendly to the republican features of our system that one of its most important securities consists in the separation of the legislative and executive powers at the same time that each is acknowledged to be supreme, in the will of the people constitutionally expressed.
    Andrew Jackson (1767–1845)

    Each reader discovers for himself that, with respect to the simpler features of nature, succeeding poets have done little else than copy his similes.
    Henry David Thoreau (1817–1862)

    “It looks as if
    Some pallid thing had squashed its features flat
    And its eyes shut with overeagerness
    To see what people found so interesting
    In one another, and had gone to sleep
    Of its own stupid lack of understanding,
    Or broken its white neck of mushroom stuff
    Short off, and died against the windowpane.”
    Robert Frost (1874–1963)