| 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 |
| Keep connection alive |
| 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 |