| Platforms |
Windows Enterprise
Edition
|
Windows Standard
Edition
|
Windows Lite
Edition
|
Mac OS X Standard
Edition
|
Mac OS X Lite
Edition
|
Linux Standard
Edition
|
Linux Lite Edition
|
|
MySQL Objects
Management
|
| Supports MySQL
Servers 3.21 or above |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Create / Drop
Databases |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Support all MySQL
objects: tables, views, stored procedures/functions and
events |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Support all subobjects:
fields, indices, foreign keys and triggers |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Support of character
set and unicode |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Connection
Management and Navigation |
| Multiple local/remote
MySQL server connections |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Connection to
MySQL Server through SSH |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Connection to
MySQL Server through HTTP |
+
|
+
|
+
|
+
|
+
|
-
|
-
|
| Support SSL secure
connection |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Keep connection
alive |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Backup connection
informations |
+
|
+
|
+
|
-
|
-
|
-
|
-
|
| Customize selected
databases to work with |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
|
Data Viewer
and Editor
|
| Grid view |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Form view |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| Text, Hex and
BLOB viewer/editor |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Copying and pasting
selected records |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Customize display
formats |
+
|
+
|
+
|
-
|
-
|
+
|
+
|
| Incremental search,
sorting and formatting table grid |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Support of raw
mode edit: apply MySQL built-in function |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Support of foreign
key data selection: locate the available values from the
reference table |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Filtering Records |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Ability to set
number of records showing on each page |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
|
SQL Processing
|
| Visual query/view
builder to facilitate the process of building complicated
queries |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Ability to create
parameter queries |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Multiple SQL editors with syntax
highlighted feature |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Code completion
for SQL editors |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| SQL console |
+
|
+
|
+
|
+
|
+
|
-
|
-
|
|
Diversified
Import and Export Competence
|
| Importing data
from ODBC: MSSQL, Oracle etc |
+
|
+
|
-
|
-
|
-
|
-
|
-
|
| Importing data
from MS Excel |
+
|
+
|
-
|
+
|
-
|
-
|
-
|
| Importing data
from MS Access |
+
|
+
|
-
|
-
|
-
|
-
|
-
|
| Importing data
from other file formats : TXT, CSV, XML, DBF etc |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Exporting data
to MS Excel |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| Exporting data
to MS Access |
+
|
+
|
-
|
-
|
-
|
-
|
-
|
| Exporting data
to HTML and PDF |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| Exporting data
to most popular formats: TXT, CSV, XML, DBF etc |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
|
Other Data Manipulation
Tools
|
| Data transfer |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Transfering data
to SQL script as INSERT statement |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Data synchronization |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Structure synchronization |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Backup/Restore |
| Backing up/restoring
database |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Restoring database
with chosen database objects |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| Converting backup file into
SQL script |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Backing up database/table to
SQL script |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Executing SQL script |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Schedule
for Batch Job |
| Ability to set schedule on backup,
query execution, import/export, data transfer and data
synchronization |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Schedule report printing |
+
|
-
|
-
|
-
|
-
|
-
|
-
|
| Schedule to print report to
files: PDF, Excel, HTML etc |
+
|
-
|
-
|
-
|
-
|
-
|
-
|
| Sending notification e-mail
for schedule task |
+
|
+
|
-
|
-
|
-
|
+
|
-
|
| Server
Security and Maintenance Services |
| Visual user manager to administer
users and privileges |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Ability to duplicate user |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Analyzing, checking, optimizing
and repairing tables |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Server Monitor to view and change
system variables, to view server status information |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Report
Management Tools |
| Report Builder. |
+
|
-
|
-
|
-
|
-
|
-
|
-
|
| Report Viewer. |
+
|
-
|
-
|
-
|
-
|
-
|
-
|
| Other
Useful Features |
| Duplicate/empty/ truncate tables |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Create table/view
shortcut on desktop |
+
|
+
|
+
|
-
|
-
|
-
|
-
|
| Print database/table Structure |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Support of docking/tab windows |
+
|
+
|
+
|
+
|
+
|
-
|
-
|
| Support of virtual grouping:
provide logical organization over objects |
+
|
+
|
-
|
+
|
-
|
+
|
-
|
| Ability to run profile from
command line |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
| Log files: keep track on the
actions have been performed in Navicat |
+
|
+
|
+
|
+
|
+
|
+
|
+
|
home
previous
