| Feature |
v. 7 |
v. 8 |
| Sending
notification e-mail for schedule task |
 |
|
| Schedule
to print report to files: PDF, Excel, HTML etc |
| Code
completion for SQL editors |
| Incremental
search |
|
Form view |
| Ability
to set NULL and Empty String as default field value |
| Create
table/view shortcut on desktop |
|
Support of virtual grouping: provide logical organization
over connections |
| Log
files: keep track on the actions have been performed in
Navicat |
| Analyze,
vacuum and reindex databases/tables |
| Server
Monitor to view server status information and system variables |
| Visual
user manager to administer users/groups and privileges |
| SQL
console |
| Ability
to run profile from command line |
| Ability
to set schedule on profiles |
| Schedule
report printing |
| Schedule
query execution |
| Schedule
backup file |
| Report
Builder/Viewer |
| Executing
SQL script |
| Backing
up database/schema/table to SQL script |
| Converting
backup file into SQL script |
| Restoring
database with chosen database objects |
| Backing
up/restoring database |
| Structure
synchronization |
| Data
synchronization |
| Transfering
data to SQL script as INSERT statement |
| Data
transfer |
| Exporting
data to most popular formats: TXT, CSV, MS Excel, MS Access,
HTML, XML, PDF, DBF etc |
| Importing
data from other file formats : TXT, CSV, MS Excel, MS
Access, XML, DBF etc |
| Importing
data from ODBC: MSSQL, Oracle etc |
| Print
database/schema/table Structure |
| Ability
to create parameter queries |
| Multiple
SQL editors with syntax highlighted feature |
| Visual
SQL builder to facilitate the process of building complicated
queries |
| Filtering
and sorting records |
| Copying
and pasting selected records |
| Customize
display formats |
| Formatting
table grid |
| Ability
to set number of records showing on each page |
| Support
of foreign key data selection: locate the available values
from the reference table |
| Support
of raw mode edit: apply PostgreSQL built-in function |
| Set
field to NULL |
| Set
field to Empty String |
| Text,
Hex and BLOB viewer/editor |
| Grid
view |
| Duplicate/empty/
truncate tables |
| Customize
selected databases to work with |
| Create
/drop databases and schemas |
| Backup
connection informations |
| Support
of docking/tab windows |
| Support
of character set and uincode |
| Managing
aggregates, conversions, domains, trigger functions, operators
and classes, sequences and types |
| Managing
cast and languages |
| Managing
tablespace |
| Support
of subobjects: fields, indices, foreign keys, uniques,
checks, rules and triggers |
| Support
PostgreSQL objects: tables, views and functions |
| Connection
to PostgreSQL Server through HTTP |
| Connection
to PostgreSQL Server through SSH |
| Multiple
local/remote PostgreSQL server connections |
| Support
connection to PostgreSQL Servers 8.0 or above |
| Working
with Windows Vista |
