Essentials Enterprise

Feature Matrix

  Essentials Enterprise
General
MySQL 3.21 or above, Drizzle, OurDelta, and Percona Server
MariaDB 5.1 or above
Oracle 8.1 or above ( Mac OS X Edition starts from Oracle 9i )
PostgreSQL 7.3 or above
SQLite 2 and 3
SQL Server 2000 or above (Windows and Mac OS X Edition only)
Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud, Google Cloud
Connection
Secure connection: SSH/HTTP/SSL
PAM and GSSAPI authentication
Export/import connection settings
Navicat Cloud
Collaboration: create projects, add members
Synchronize connections and queries
Synchronize models and virtual groups
Data Viewer and Editor
Grid view
Form view
Foreign key data selection
Text, Hex, Image, Web, BFile and Dynamic Column viewer/editor
Raw mode editing
Find and replace
Filter records
SQL Processing
PL/SQL and PL/PGSQL Debugger
SQL Editor
Visual SQL Builder
Code Snippet and Completion
SQL Code Beautifier/Minifier
Find and replace
Create parameter queries
Open query files in an external editor (Windows and Mac OS X Edition only)
SQL console (Windows and Mac OS X Edition only)
Data Modeling
Physical model
Reverse/forward engineering
Auto layout
Add vertices, layers, images, notes, labels and shapes
Print database diagrams to PDF and graphic files
Import/Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON
Import/export data from/to most popular formats: DBF etc
Import data from ODBC, MS Excel, MS Access
Export data to MS Excel
Export data to MS Access (Windows and Mac OS X Edition only)
Export data to HTML (Windows and Linux Edition only)
Data Manipulation
Data Transfer (Same or cross server type)
Data/Structure Synchronization
Backup/Restore
Backup/restore MySQL/MariaDB/ PostgreSQL/SQLite database
Convert backup file into SQL script
Oracle Data Pump
SQL Server Backup/Restore (Windows and Mac OS X Edition only)
Dump/Execute SQL file
Automation
Set schedule on backup, query execution, import/export, data transfer and data synchronization
Schedule report printing - Printer, PDF, Excel, HTML, etc (Windows Edition only)
Run profiles from different servers in a single batch job
Include attachment for export file/report in notification email
Server Security
Manage user
Server Monitor
Other Useful Features
Report Builder (Windows Edition only)
ER Diagram view
Virtual grouping
Customize connection colorings
Database wide search
Favorites list
Print database/schema/table structure
Run profile from command line
General
MySQL 3.21 or above, Drizzle, OurDelta, and Percona Server Enterprise
Essential
MariaDB 5.1 or above Enterprise
Essential
Oracle 8.1 or above ( Mac OS X Edition starts from Oracle 9i ) Enterprise
Essential
PostgreSQL 7.3 or above Enterprise
Essential
SQLite 2 and 3 Enterprise
Essential
SQL Server 2000 or above (Windows and Mac OS X Edition only) Enterprise
Essential
Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud, Google Cloud Enterprise
Essential
Connection
Secure connection: SSH/HTTP/SSL Enterprise
Essential
PAM and GSSAPI authentication Enterprise
Essential
Export/import connection settings Enterprise
Essential
Navicat Cloud
Collaboration: create projects, add members Enterprise
Essential
Synchronize connections and queries Enterprise
Essential
Synchronize models and virtual groups Enterprise
Data Viewer and Editor
Grid view Enterprise
Essential
Form view Enterprise
Foreign key data selection Enterprise
Text, Hex, Image, Web, BFile and Dynamic Column viewer/editor Enterprise
Essential
Raw mode editing Enterprise
Essential
Find and replace Enterprise
Essential
Filter records Enterprise
Essential
SQL Processing
PL/SQL and PL/PGSQL Debugger Enterprise
SQL Editor Enterprise
Essential
Visual SQL Builder Enterprise
Code Snippet and Completion Enterprise
SQL Code Beautifier/Minifier Enterprise
Find and replace Enterprise
Essential
Create parameter queries Enterprise
Essential
Open query files in an external editor (Windows and Mac OS X Edition only) Enterprise
Essential
SQL console (Windows and Mac OS X Edition only) Enterprise
Essential
Data Modeling
Physical model Enterprise
Reverse/forward engineering Enterprise
Auto layout Enterprise
Add vertices, layers, images, notes, labels and shapes Enterprise
Print database diagrams to PDF and graphic files Enterprise
Import/Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON Enterprise
Essential
Import/export data from/to most popular formats: DBF etc Enterprise
Import data from ODBC, MS Excel, MS Access Enterprise
Export data to MS Excel Enterprise
Export data to MS Access (Windows and Mac OS X Edition only) Enterprise
Export data to HTML (Windows and Linux Edition only) Enterprise
Data Manipulation
Data Transfer (Same or cross server type) Enterprise
Data/Structure Synchronization Enterprise
Backup/Restore
Backup/restore MySQL/MariaDB/PostgreSQL/SQLite database Enterprise
Convert backup file into SQL script Enterprise
Oracle Data Pump Enterprise
SQL Server Backup/Restore (Windows and Mac OS X Edition only) Enterprise
Dump/Execute SQL file Enterprise
Essential
Automation
Set schedule on backup, query execution, import/export, data transfer and data synchronization Enterprise
Schedule report printing - Printer, PDF, Excel, HTML, etc (Windows Edition only) Enterprise
Run profiles from different servers in a single batch job Enterprise
Include attachment for export file/report in notification email Enterprise
Server Security
Manage user Enterprise
Essential
Server Monitor Enterprise
Other Useful Features
Report Builder (Windows Edition only) Enterprise
ER Diagram view Enterprise
Virtual grouping Enterprise
Customize connection colorings Enterprise
Essential
Database wide search Enterprise
Favorites list Enterprise
Print database/schema/table structure Enterprise
Run profile from command line Enterprise