Press Releases

  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 ( macOS Edition starts from Oracle 9i )
PostgreSQL 7.3 or above
SQLite 2 and 3
SQL Server 2000 or above (Windows and macOS 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 macOS Edition only)
SQL console (Windows and macOS 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 macOS 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 macOS 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
Essentials
MariaDB 5.1 or above Enterprise
Essentials
Oracle 8.1 or above ( macOS Edition starts from Oracle 9i ) Enterprise
Essentials
PostgreSQL 7.3 or above Enterprise
Essentials
SQLite 2 and 3 Enterprise
Essentials
SQL Server 2000 or above (Windows and macOS Edition only) Enterprise
Essentials
Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud, Google Cloud Enterprise
Essentials
Connection
Secure connection: SSH/HTTP/SSL Enterprise
Essentials
PAM and GSSAPI authentication Enterprise
Essentials
Export/import connection settings Enterprise
Essentials
Navicat Cloud
Collaboration: create projects, add members Enterprise
Essentials
Synchronize connections and queries Enterprise
Essentials
Synchronize models and virtual groups Enterprise
Data Viewer and Editor
Grid view Enterprise
Essentials
Form view Enterprise
Foreign key data selection Enterprise
Text, Hex, Image, Web, BFile and Dynamic Column viewer/editor Enterprise
Essentials
Raw mode editing Enterprise
Essentials
Find and replace Enterprise
Essentials
Filter records Enterprise
Essentials
SQL Processing
PL/SQL and PL/PGSQL Debugger Enterprise
SQL Editor Enterprise
Essentials
Visual SQL Builder Enterprise
Code Snippet and Completion Enterprise
SQL Code Beautifier/Minifier Enterprise
Find and replace Enterprise
Essentials
Create parameter queries Enterprise
Essentials
Open query files in an external editor (Windows and macOS Edition only) Enterprise
Essentials
SQL console (Windows and macOS Edition only) Enterprise
Essentials
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
Essentials
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 macOS 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 macOS Edition only) Enterprise
Dump/Execute SQL file Enterprise
Essentials
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
Essentials
Server Monitor Enterprise
Other Useful Features
Report Builder (Windows Edition only) Enterprise
ER Diagram view Enterprise
Virtual grouping Enterprise
Customize connection colorings Enterprise
Essentials
Database wide search Enterprise
Favorites list Enterprise
Print database/schema/table structure Enterprise
Run profile from command line Enterprise