|
Feature Matrix for Navicat Essentials
Platforms
* ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
|
MySQL Objects Management
|
|
|
|
| Support MySQL Servers 3.21 or above |
|
|
|
| Support of Drizzle, OurDelta, Percona Server and MariaDB |
|
|
|
| Create / Drop Databases |
|
|
|
| Support all MySQL objects: tables, views, procedures/functions and events |
|
|
|
| Support all subobjects: fields, indexes, foreign keys and triggers |
|
|
|
| Support of partitioning |
|
|
|
| Support of character set and unicode |
|
|
|
|
Oracle Objects Management
|
|
|
|
| Support Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7) |
|
|
|
| Create/drop schemas |
|
|
|
| Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing directories, tablespaces, public database links and public synonyms |
|
|
|
| Managing database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin |
|
|
|
| Support of physical attributes |
|
|
|
| Support of character set and unicode |
|
|
|
|
PostgreSQL Objects Management
|
|
|
|
| Support PostgreSQL Servers 7.3 or above |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all PostgreSQL objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks, rules and triggers |
|
|
|
| Managing tablespace |
|
|
|
| Managing cast and languages |
|
|
|
| Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types |
|
|
|
| Support of character set and unicode |
|
|
|
|
SQLite Objects Management
|
|
|
|
| Support SQLite 2 and 3 |
|
|
|
| Attach/detach databases |
|
|
|
| Support all SQLite objects: tables and views |
|
|
|
| Support all subobjects: triggers and indexes |
|
|
|
| Support to view master table |
|
|
|
| Support of character set and unicode |
|
|
|
|
SQL Server Objects Management
|
|
|
|
| Support SQL Server 2000 or above |
|
|
|
| Support SQL Azure |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all SQL Server objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing linked servers, server triggers |
|
|
|
| Managing assemblies, partition functions, partition schemes and database triggers |
|
|
|
| Managing indexes, synonyms and triggers |
|
|
|
| Support of character set and unicode |
|
|
|
|
Connection Management and Navigation
|
|
|
|
| Multiple local/remote server connections |
|
|
|
| Support of Oracle Basic Connection |
|
|
|
| Support of Oracle TNS Connection |
|
|
|
| Support to connect a new or an existing SQLite database |
|
|
|
| Support encrypted SQLite file (wxSQLite3) |
|
|
|
| Connection to MySQL/Oracle/PostgreSQL/SQL Server through SSH |
|
|
|
| Connection to MySQL/PostgreSQL/SQLite through HTTP |
|
|
|
| Support SSL secure connection for MySQL and PostgreSQL 8.4 above |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Customize selected MySQL/PostgreSQL databases to work with |
|
|
|
|
Feature Rich Oracle PL/SQL Code Debugger
|
|
|
|
| Support on showing interactive and real-time debugging information |
|
|
|
| Ability to set simple and complex breakpoints |
|
|
|
| Stepping through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
| Inspecting variables and expressions |
|
|
|
| Stack traces |
|
|
|
|
Data Viewer and Editor
|
|
|
|
| UUID/GUID generator for PostgreSQL/SQL Server |
|
|
|
| Grid view |
|
|
|
| Form view |
|
|
|
| Text, Hex and BLOB viewer/editor |
|
|
|
| Oracle BFile viewer/editor |
|
|
|
| Copying and pasting selected records |
|
|
|
| Customize display formats |
|
|
|
| Incremental search, sorting and formatting table grid |
|
|
|
| Ability to show/hide Oracle and SQLite tables ROWID |
|
|
|
| Support of raw mode edit: apply MySQL/PostgreSQL/SQLite/SQL Server 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| Code outline |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
|
Data Modeling Tools
|
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
|
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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats: TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
|
Other Data Manipulation Tools
|
|
|
|
| Data transfer (Same or cross server type) |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Structure synchronization |
|
|
|
|
Backup/Restore for MySQL/PostgreSQL/SQLite
|
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| Restoring database with chosen database objects |
|
|
|
| Converting backup file into SQL script |
|
|
|
| Compressing/Decompressing Backup files |
|
|
|
|
Schedule for Batch Job
|
|
|
|
| Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization |
|
|
|
| Ability to run profiles from different servers in a single schedule job |
|
|
|
| Schedule report printing |
|
|
|
| Schedule to print report to files: PDF, Excel, HTML etc |
|
|
|
| Sending notification e-mail for schedule task |
|
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
|
Server Security and Maintenance Services
|
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role, etc |
|
|
|
| Maintance database/schema objects |
|
|
|
| Server Monitor to view and change system variables and server status information |
|
|
|
|
Report Management Tools
|
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
|
Other Useful Features
|
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print database/schema/table structure |
|
|
|
| Support of docking/tab windows |
|
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
|
| Ability to run profile from command line |
|
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
| Ability to copy Connection Information into Clipboard |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| MySQL Objects Management |
|
|
|
| Support MySQL Servers 3.21 or above |
|
|
|
| Support of Drizzle, OurDelta, Percona Server and MariaDB |
|
|
|
| Create / Drop Databases |
|
|
|
| Support all MySQL objects: tables, views, stored procedures/functions and events |
|
|
|
| Support all subobjects: fields, indexes, foreign keys and triggers |
|
|
|
| Support of partitioning |
|
|
|
| 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 |
|
|
|
| Export/Import connections settings |
|
|
|
| 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats: TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Structure synchronization |
|
|
|
| Backup / Restore |
|
|
|
| Backing up / restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| Restoring database with chosen database objects |
|
|
|
| Converting backup file into SQL script |
|
|
|
| Compressing/Decompressing Backup files |
|
|
|
| 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 |
|
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user |
|
|
|
| Maintance database objects |
|
|
|
| Server Monitor to view and change system variables, to view server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print database/table Structure |
|
|
|
| Support of docking/tab windows |
|
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
|
| Ability to run profile from command line |
|
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
| Ability to copy Connection Information into Clipboard |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
| SQL Server Objects Management |
|
|
| Support SQL Server 2000 or above |
|
|
| Support SQL Azure |
|
|
| Create /drop databases and schemas |
|
|
| Support all SQL Server objects: tables, views and functions |
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
| Managing linked servers, server triggers |
|
|
| Managing assemblies, partition functions, partition schemes and database triggers |
|
|
| Managing indexes, synonyms and triggers |
|
|
| Support of character set and unicode |
|
|
| Connection Management and Navigation |
|
|
| Multiple local/remote SQL Server server connections |
|
|
| Connection to SQL Server through SSH |
|
|
| Keep connection alive |
|
|
| Export/Import connections settings |
|
|
| Data Viewer and Editor |
|
|
| UUID/GUID Generator |
|
|
| 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 SQL Server 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 |
|
|
| Code completion for SQL editors |
|
|
| Code outline |
|
|
| SQL Code Beautifier/Minifier |
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
| Support code folding, highlighted matches words and brackets |
|
|
| Copy SQL with quote |
|
|
| Word Wrap |
|
|
| Zoom In/Out for SQL editors |
|
|
| Enhanced find and replace options in SQL editors |
|
|
| Ability to preview SQL before execution |
|
|
| Support to return multi-resultsets |
|
|
| SQL console |
|
|
| Data Modeling Tools |
|
|
| Reverse engineering |
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
| Support of auto layout |
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
| Zoom In/Out for ER diagram |
|
|
| Comparing and synchronizing database/model |
|
|
| Generating complex SQL/DDL |
|
|
| Multi-page print preview |
|
|
| Ability to print the database diagram to PDF file |
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
| Importing data from other file formats : DBF etc |
|
|
| Exporting data to MS Excel |
|
|
| Exporting data to MS Access |
|
|
| Exporting data to HTML |
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
| Exporting data to most popular formats: DBF etc |
|
|
| Other Data Manipulation Tools |
|
|
| Data transfer |
|
|
| Transferring data to SQL script as INSERT statement |
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
| Data synchronization |
|
|
| Structure synchronization |
|
|
| Schedule for Batch Job |
|
|
| Ability to set schedule on 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 |
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
| Notification email Support SSL/TLS |
|
|
| Server Security and Maintenance Services |
|
|
| Visual user management |
|
|
| Visual privilege manager |
|
|
| Ability to duplicate user, role, etc |
|
|
| Maintance database/schema objects |
|
|
| Server Monitor to view system variables and server status information |
|
|
| Report Management Tools |
|
|
| Report Builder |
|
|
| Report Viewer |
|
|
| Other Useful Features |
|
|
| ER Diagram view |
|
|
| Ability to customize connection colorings |
|
|
| Support of database wide search |
|
|
| Objects search filter |
|
|
| Backing up schema/table to SQL script |
|
|
| Executing SQL script |
|
|
| Duplicate/empty tables |
|
|
| Create table/view shortcut on desktop |
|
|
| Ability to create Favorites list |
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
| Print database/table Structure |
|
|
| Support of docking/tab windows |
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
| Ability to run profile from command line |
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
| Ability to copy Connection Information into Clipboard |
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| SQLite Objects Management |
|
|
|
| Support SQLite 2 and 3 |
|
|
|
| Attach/detach databases |
|
|
|
| Support all SQLite objects: tables and views |
|
|
|
| Support all subobjects: triggers and indexes |
|
|
|
| Support to view master table |
|
|
|
| Support of character set and unicode |
|
|
|
| Connection Management and Navigation |
|
|
|
| Multiple local/remote SQLite database connections |
|
|
|
| Support to connect a new or an existing database |
|
|
|
| Support encrypted SQLite file (wxSQLite3) |
|
|
|
| Connection to SQLite database through HTTP |
|
|
|
| Export/Import connections settings |
|
|
|
| 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 SQLite built-in function |
|
|
|
| Ability to show/hide ROWID |
|
|
|
| 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL Console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Backup/Restore |
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| Restoring database with chosen database objects |
|
|
|
| Converting backup file into SQL script |
|
|
|
| Compressing/Decompressing Backup files |
|
|
|
| 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 |
|
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Analyzing, re-indexing tables |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up database/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, etc |
|
|
|
| Print database/table Structure |
|
|
|
| Support of docking/tab windows |
|
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
|
| Ability to run profile from command line |
|
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
| Ability to copy Connection Information into Clipboard |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| Oracle Objects Management |
|
|
|
| Support Oracle Servers 8.1 or above (Mac OS X Edition starts from Oracle 8.1.7) |
|
|
|
| Create/drop schemas |
|
|
|
| Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks and triggers |
|
|
|
| Managing directories, tablespaces, public database links and public synonyms |
|
|
|
| Managing database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin. |
|
|
|
| Support of physical attributes |
|
|
|
| Support of character set and unicode |
|
|
|
| Connection Management and Navigation |
|
|
|
| Multiple local/remote Oracle server connections |
|
|
|
| Support of Basic Connection |
|
|
|
| Support of TNS Connection |
|
|
|
| Connection to Oracle Server through SSH |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Feature Rich Oracle PL/SQL Code Debugger |
|
|
|
| Support on showing interactive and real-time debugging information |
|
|
|
| Ability to set simple and complex breakpoints |
|
|
|
| Stepping through a function, i.e. Step Into, Step Over and Step Out |
|
|
|
| Inspecting variables and expressions |
|
|
|
| Stack traces |
|
|
|
| Data Viewer and Editor |
|
|
|
| Grid view |
|
|
|
| Form view |
|
|
|
| TEXT, Hex and BLOB/BFile viewer/editor |
|
|
|
| Copying and pasting selected records |
|
|
|
| Customize display formats |
|
|
|
| Incremental search, sorting and formatting table grid |
|
|
|
| Ability to show/hide table ROWID |
|
|
|
| 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| Code outline |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL*Plus |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| Diversified Import and Export Competence |
|
|
|
| Importing data from ODBC: MSSQL etc |
|
|
|
| Importing data from MS Excel |
|
|
|
| Importing data from MS Access |
|
|
|
| Importing data from plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Structure synchronization |
|
|
|
| Schedule for Batch Job |
|
|
|
| Ability to set schedule on 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 |
|
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role |
|
|
|
| Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics |
|
|
|
| Server Monitor to view and change system variables, to view server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print Schema Structure |
|
|
|
| Support of docking/tab windows |
|
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
|
| Ability to run profile from command line |
|
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
| Ability to copy Connection Information into Clipboard |
|
|
|
Platforms
*ESS: Essentials Edition. |
Win
ESS
|
Mac
ESS
|
Linux
ESS
|
| PostgreSQL Objects Management |
|
|
|
| Support PostgreSQL Servers 7.3 or above |
|
|
|
| Create /drop databases and schemas |
|
|
|
| Support all PostgreSQL objects: tables, views and functions |
|
|
|
| Support all subobjects: fields, indexes, foreign keys, uniques, checks, rules and triggers |
|
|
|
| Managing tablespace |
|
|
|
| Managing cast and languages |
|
|
|
| Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types |
|
|
|
| Support of character set and unicode |
|
|
|
| Connection Management and Navigation |
|
|
|
| Multiple local/remote PostgreSQL server connections |
|
|
|
| Connection to PostgreSQL Server through SSH |
|
|
|
| Connection to PostgreSQL Server through HTTP |
|
|
|
| Support SSL secure connection for PostgreSQL 8.4 above |
|
|
|
| Keep connection alive |
|
|
|
| Export/Import connections settings |
|
|
|
| Customize selected databases to work with |
|
|
|
| Data Viewer and Editor |
|
|
|
| UUID/GUID Generator |
|
|
|
| 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 PostgreSQL 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 |
|
|
|
| Code completion for SQL editors |
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
| Multiple SQL editors with syntax highlighted feature |
|
|
|
| Support code folding, highlighted matches words and brackets |
|
|
|
| Copy SQL with quote |
|
|
|
| Word Wrap |
|
|
|
| Zoom In/Out for SQL editors |
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
| Ability to preview SQL before execution |
|
|
|
| Support to return multi-resultsets |
|
|
|
| SQL console |
|
|
|
| Data Modeling Tools |
|
|
|
| Reverse engineering |
|
|
|
| Support of several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
|
| Ability to create/edit/drop database objects, visually set relationships between them |
|
|
|
| Support of auto layout |
|
|
|
| Support numerous visual customization options like adding vertices, layers, images and notes/labels |
|
|
|
| Zoom In/Out for ER diagram |
|
|
|
| Comparing and synchronizing database/model |
|
|
|
| Generating complex SQL/DDL |
|
|
|
| Multi-page print preview |
|
|
|
| Ability to print the database diagram to PDF file |
|
|
|
| Ability to save the database diagram as a graphic file, i.e. PNG, SVG |
|
|
|
| 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 plain text file formats : TXT, CSV, XML etc |
|
|
|
| Importing data from other file formats : DBF etc |
|
|
|
| Exporting data to MS Excel |
|
|
|
| Exporting data to MS Access |
|
|
|
| Exporting data to HTML |
|
|
|
| Exporting data to plain text file formats : TXT, CSV, XML etc |
|
|
|
| Exporting data to most popular formats: DBF etc |
|
|
|
| Other Data Manipulation Tools |
|
|
|
| Data transfer |
|
|
|
| Transferring data to SQL script as INSERT statement |
|
|
|
| Transferring data to a SQL file with designated SQL format and encoding |
|
|
|
| Data synchronization |
|
|
|
| Structure synchronization |
|
|
|
| Backup/Restore |
|
|
|
| Backing up/restoring database |
|
|
|
| Backing up database with chosen database objects |
|
|
|
| Restoring database with chosen database objects |
|
|
|
| Converting backup file into SQL script |
|
|
|
| Compressing/Decompressing Backup files |
|
|
|
| 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 |
|
|
|
| Ability to attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
| Notification email Support SSL/TLS |
|
|
|
| Server Security and Maintenance Services |
|
|
|
| Visual user management |
|
|
|
| Visual privilege manager |
|
|
|
| Ability to duplicate user, role, etc |
|
|
|
| Analyzing, vacuuming and reindexing tables |
|
|
|
| Server Monitor to view system variables and server status information |
|
|
|
| Report Management Tools |
|
|
|
| Report Builder |
|
|
|
| Report Viewer |
|
|
|
| Other Useful Features |
|
|
|
| ER Diagram view |
|
|
|
| Ability to customize connection colorings |
|
|
|
| Support of database wide search |
|
|
|
| Objects search filter |
|
|
|
| Backing up schema/table to SQL script |
|
|
|
| Executing SQL script |
|
|
|
| Duplicate/empty/truncate tables |
|
|
|
| Create table/view shortcut on desktop |
|
|
|
| Ability to create Favorites list |
|
|
|
| Ability to set auto-save for Query, Function, etc |
|
|
|
| Print database/table Structure |
|
|
|
| Support of docking/tab windows |
|
|
|
| Support of virtual grouping: provide logical organization over connections and objects |
|
|
|
| Ability to run profile from command line |
|
|
|
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
| Ability to copy Connection Information into Clipboard |
|
|
|
|
View Cart [ 
