Home Products Navicat for MySQL Version History

Version History

Windows

Feature v. 4 v. 5 v. 6 v. 7 v. 8 v. 9
History Log Viewer
Ability to set favorites list
Object filter
Ability to set auto save in Query, Function etc
Ability to copy SQL statement with quote in Query
Custom sorting in Table Viewer
Support of sending SSL/TLS e-mail for schedule task
Backup database with chosen database objects
Code folding
Zoom in/Zoom out
Matched brace/bracket highlighting feature
Word completion for SQL editors
Support unicode character reports
SQL Beautifier
Export/Import Connections
Code completion for SQL editors
Support of virtual grouping: provide logical organization over objects
Schedule to sent notification e-mail with file attachment - Export Wizard/Report result files
Schedule to print report to files: PDF, Excel, HTML etc
Ability to transfer data to a SQL file with designated SQL format and encoding
Server Monitor to change system variables
Ability to duplicate user
Support of Compress Backup and Decompress Backup
Incremental search
Support of multi-resultset in Query, Stored Procedure
Ability to preview SQL before execution
Ability to set NULL and Empty String as default field value
Form view
Create table/view shortcut on desktop
Backup connection informations
Support of Preview and Explain in Query/View Designer
Support of event and partitioning
Working with Windows 7
SQL console
Data synchronization
Structure synchronization
Restoring database with chosen database objects
Ability to create parameter queries
Support of foreign key data selection: locate the available values from the reference table
Truncate table
Support of triggers
Keep connection alive
Connection to MySQL Server through HTTP
Connection to MySQL Server through SSH public key authentication
Working with Windows Vista
Log files: keep track on the actions have been performed in Navicat
Importing data from ODBC: MSSQL, Oracle etc
Ability to set schedule on profiles
Schedule report printing
Schedule query execution
Print database/table Structure
Support of docking/tab windows
Text, Hex and BLOB viewer/editor
Formatting table grid
Support of stored procedures/functions
Support of views
Support of character set and unicode
Connection to MySQL Server through SSH
Support connection to all MySQL versions
Transfering data to SQL script as INSERT statement
Backing up database/table to SQL script
Executing SQL script
Multiple SQL editors with syntax highlighted feature
Support of raw mode edit: apply MySQL built-in function
Customize display formats
Set field to Empty String
Duplicate table
Empty table
Support of foreign keys
Support SSL secure connection
Analyzing, checking, optimizing and repairing tables
Server Monitor to view server status information and system variables
Visual user manager to administer users and privileges
Ability to run profile from command line
Report Builder/Viewer
Schedule backup file
Converting backup file into SQL script
Backing up/restoring database
Data transfer
Importing data from MS Excel and MS Access
Importing data from other file formats : TXT, CSV, XML, DBF etc
Exporting data to MS Excel and MS Access
Exporting data to most popular formats: TXT, CSV, HTML, XML, PDF, DBF etc
Visual SQL builder to facilitate the process of building complicated queries
Set field to NULL
Filtering and sorting records
Copying and pasting selected records
Ability to set number of records showing on each page
Grid view
Support of fields and indices
Support of tables
Customize selected databases to work with
Create / drop databases
Multiple local/remote MySQL server connections

Mac OS X

Feature v. 5 v. 6 v. 7 v. 8 v. 9
History Query Log Viewer
Ability to set favorites list
Object filter
Ability to set auto save in Query, Function etc
Ability to copy SQL statement with quote in Query
Custom sorting in Table Viewer
Backup database with chosen database objects
Code folding
Zoom in/Zoom out
Matched brace/bracket highlighting feature
Word completion for SQL editors
SQL Beautifier
Export/Import Connections
Ability to duplicate connection
Ability to preview SQL before execution
Sending notification e-mail for schedule task, with option to attach file output from Export Wizard or Data Transfer.
Ability to transfer data to a SQL file with designated SQL format and encoding
Importing data from ODBC: MSSQL, Oracle etc
Exporting data to MS Excel
Code completion for SQL editors
Form view
Create table/view/import and export profile shortcut on desktop
Support of Partitioning
Support of virtual grouping: provide logical organization over objects
Support of docking/tab windows
Ability to duplicate user
Server Monitor to change system variables
Importing data from MS Excel
Incremental search
Support of raw mode edit: apply MySQL built-in function
Formatting table grid
Hex viewer/editor
Ability to set NULL and Empty String as default field value
Truncate table
Support of events
Keep connection alive
Connection to MySQL Server through SSH public key authentication
Compatible with Mac OS X Leopard
SQL console
Structure synchronization
Data synchronization
Ability to create parameter queries
Multiple SQL editors with syntax highlighted feature
Support of drag and drop objects (tables only in version 6.x)
Support of foreign key data selection: locate the available values from the reference table
Support of views
Support of triggers
Connection to MySQL Server through HTTP
Connection to MySQL Server through SSH
Log files: keep track on the actions have been performed in Navicat
Server Monitor to view server status information and system variables
Visual user manager to administer users and privileges
Ability to run profile from command line
Ability to set schedule on profiles
Schedule backup file and query execution
Executing SQL script
Backing up database/table to SQL script
Converting backup file into SQL script
Backing up/restoring database
Transfering data to SQL script as INSERT statement
Data transfer
Exporting data to most popular formats: TXT, CSV, XML and DBF
Importing data from : TXT, CSV, XML and DBF
View database/table structure in HTML format
Visual SQL builder to facilitate the process of building complicated queries
Filtering and sorting records
Copying and pasting selected records
Ability to set number of records showing on each page
Set field to NULL
Text and BLOB viewer/editor
Grid view
Empty and duplicate table
Analyzing, checking, optimizing and repairing tables
Support of stored procedures/functions
Support of fields, indices and foreign keys
Support of tables
Customize selected databases to work with
Create / drop databases
Support of character set and unicode
Support SSL secure connection
Multiple local/remote MySQL server connections
Support connection to all MySQL versions

Linux

Feature v. 6 v. 8 v. 9
History Log Viewer
Ability to set favorites list
Object filter
Ability to set auto save in Query, Function etc
Ability to copy SQL statement with quote in Query
Custom sorting in Table Viewer
Support of sending SSL/TLS e-mail for schedule task
Backup database with chosen database objects
Code folding
Zoom in/Zoom out
Matched brace/bracket highlighting feature
Word completion for SQL editors
Support unicode character reports
SQL Beautifier
Export/Import Connections
Support of virtual grouping: provide logical organization over objects
Schedule to sent notification e-mail with file attachment - Export Wizard result files
Ability to transfer data to a SQL file with designated SQL format and encoding
Server Monitor to change system variables
Ability to duplicate user
Print database/table Structure
Support of Compress Backup and Decompress Backup
Restoring database with chosen database objects
Structure synchronization
Data synchronization
Exporting data to MS Excel and PDF
Log files: keep track on the actions have been performed in Navicat
Ability to preview SQL before execution
Ability to create parameter queries
Support of Preview and Explain in Query/View Designer
Support of multi-resultset in Query, Stored Procedure
Code completion for SQL editors
Multiple SQL editors with syntax highlighted feature
Support of foreign key data selection: locate the available values from the reference table
Incremental search
Form view
Hex viewer/editor
Truncate table
Ability to set NULL and Empty String as default field value
Support of triggers, events and partitioning
Support of character set and unicode
Keep connection alive
Backup connection informations
Connection to MySQL Server through HTTP
Connection to MySQL Server through SSH together with public key authentication method
Analyzing, checking, optimizing and repairing tables
Server Monitor to view server status information and system variables
Visual user manager to administer users and privileges
Ability to run profile from command line
Ability to set schedule on profiles
Schedule query execution
Schedule backup file
Converting backup file into SQL script
Executing SQL script
Backing up database/table to SQL script
Backing up/restoring database
Transfering data to SQL script as INSERT statement
Data transfer
Importing data from: TXT, CSV, XML, DBF etc
Exporting data to most popular formats: TXT, CSV, HTML, XML, DBF etc
Visual SQL builder to facilitate the process of building complicated queries
Filtering and sorting records
Copying and pasting selected records
Ability to set number of records showing on each page
Set field to NULL and Empty String
Support of raw mode edit: apply MySQL built-in function
Customize display formats
Formatting table grid
Text and BLOB viewer/editor
Grid view
Empty and duplicate table
Support of fields, indices and foreign keys
Support of tables, stored procedures and functions
Customize selected databases to work with
Create / drop databases
Support SSL secure connection
Connection to MySQL Server through SSH
Multiple local/remote MySQL server connections
Support connection to all MySQL versions