| Platforms |
Windows Enterprise Edition
|
Windows Standard Edition
|
Windows Lite Edition
|
Mac OS X Standard Edition
|
|
Linux Standard Edition
|
Linux Lite Edition
|
| MySQL
Objects Management |
|
Support 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 |
|
|
|
|
|
|
|
