| Feature |
v. 6 |
v. 8 |
| Server
Monitor to change system variables |
 |
|
| Ability
to duplicate user |
| Log
files: keep track on the actions have been performed in
Navicat |
| Support
of virtual grouping: provide logical organization over
objects |
| Sending
notification e-mail for schedule task |
| Restoring
database with chosen database objects |
| Structure
synchronization |
| Data
synchronization |
| Exporting
data to MS Excel and PDF |
| Code
completion for SQL editors |
| Ability
to create parameter queries |
| Multiple
SQL editors with syntax highlighted feature |
| Print
database/table Structure |
| Support
of foreign key data selection: locate the available values
from the reference table |
| Support
of raw mode edit: apply MySQL built-in function |
| Incremental
search |
| Hex
viewer/editor |
| Form
view |
| Ability
to set NULL and Empty String as default field value |
| Truncate
table |
| Support
of events |
| Support
of views |
| Support
of triggers |
| Support
of character set and unicode |
| Keep
connection alive |
| Connection
to MySQL Server through SSH together with public key authentication
method |
| Visual
user manager to administer users and privileges |
| Analyzing,
checking, optimizing and repairing tables |
| Server
Monitor to view server status information and system variables |
| Ability
to run profile from command line |
| Ability
to set schedule on profiles |
| Schedule
query execution |
| Schedule
backup file |
| 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, HTML, XML, DBF
etc |
| Importing
data from TXT, CSV, XML, DBF, HTML etc |
| Visual
SQL builder to facilitate the process of building complicated
queries |
| Customize
display formats |
| Formatting
table grid |
| 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 |
| Text
and BLOB viewer/editor |
| Grid
view |
| Empty
and duplicate table |
| 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
SSL secure connection |
| Multiple
local/remote MySQL server connections |
| Support
connection to all MySQL versions |
|Deutsch
|Français
|Language
| Contact
