Standard Enterprise

Feature Matrix

  Standard Enterprise
Connection
SQL Server 2000 or later
Amazon AWS, Microsoft Azure, Google Cloud, Alibaba Cloud, Tencent Cloud, Huawei Cloud
Secure connection: SSH
Windows Authentication/Active Directory (Windows Edition only)
Centralized connection management
Connection profiles
Customize connection colorings
Export/import connection settings
Navicat Collaboration
Collaboration: create projects, add members
Synchronize connection settings, queries, snippets and virtual group information
Synchronize BI workspaces and model workspaces
Data Viewer and Editor
Grid view
Form view
Data profiling
Text, hex, image or web viewer and editor
Foreign key data selection
Filter and sort
Table profile
Find and replace
Query Processing
Query editor with syntax highlight
Code completion
Code snippet
Query builder
Visual explain
Pin query result
SQL beautifier and minifier
Find and replace
Create parameter queries
Console
Object Designer
Database object design tools
View builder
SQL preview
BI
Over 20 chart type options
Visualize live data
Customized fields
Customize multiple pages dashboard
Add interactive controls
Present mode
Model
Physical model
Reverse database to model
Synchronize database to model
Synchronize model to database
Export model to SQL file
Compare model workspaces
Auto layout
Add vertices, layers, images, notes, labels and shapes
Print database diagrams to PDF and graphic files
Import and Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON
Import data from ODBC, MS Excel, MS Access, DBF
Export data to MS Excel, DBF
Export data to MS Access (Windows Edition only)
Structure and Data Manipulation
Structure synchronization
Data transfer
Data synchronization
Data generation
Data dictionary
Copy and paste data across databases
Backup and Restore
SQL Server Backup/Restore
Dump/execute SQL file
Automation
Set schedule on : query, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export
Run profiles from different servers in a single batch job
Include attachment for export file in notification email
Server Security
Manage user
Server monitor
Other Useful Features
ER diagram view
Open object via URI
Virtual grouping
Database wide search
Favorites list
Focus mode
Dark mode
Connection
SQL Server 2000 or later Enterprise
Standard
Amazon AWS, Microsoft Azure, Google Cloud, Alibaba Cloud, Tencent Cloud, Huawei Cloud Enterprise
Standard
Secure connection: SSH Enterprise
Standard
Windows Authentication/Active Directory (Windows Edition only) Enterprise
Standard
Centralized connection management Enterprise
Standard
Connection profiles Enterprise
Standard
Customize connection colorings Enterprise
Standard
Export/import connection settings Enterprise
Standard
Navicat Collaboration
Collaboration: create projects, add members Enterprise
Standard
Synchronize connection settings, queries, snippets and virtual group information Enterprise
Standard
Synchronize BI workspaces and model workspaces Enterprise
Data Viewer and Editor
Grid view Enterprise
Standard
Form view Enterprise
Standard
Data profiling Enterprise
Standard
Text, hex, image or web viewer and editor Enterprise
Standard
Foreign key data selection Enterprise
Standard
Filter and sort Enterprise
Standard
Table profile Enterprise
Standard
Find and replace Enterprise
Standard
Query Processing
Query editor with syntax highlight Enterprise
Standard
Code completion Enterprise
Standard
Code snippet Enterprise
Standard
Query builder Enterprise
Standard
Visual explain Enterprise
Standard
Pin query result Enterprise
Standard
SQL beautifier and minifier Enterprise
Standard
Find and replace Enterprise
Standard
Create parameter queries Enterprise
Standard
Console Enterprise
Standard
Object Designer
Database object design tools Enterprise
Standard
View builder Enterprise
Standard
SQL preview Enterprise
Standard
BI
Over 20 chart type options Enterprise
Visualize live data Enterprise
Customized fields Enterprise
Customize multiple pages dashboard Enterprise
Add interactive controls Enterprise
Present mode Enterprise
Model
Physical model Enterprise
Reverse database to model Enterprise
Synchronize database to model Enterprise
Synchronize model to database Enterprise
Export model to SQL file Enterprise
Compare model workspaces Enterprise
Auto layout Enterprise
Add vertices, layers, images, notes, labels and shapes Enterprise
Print database diagrams to PDF and graphic files Enterprise
Import and Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON Enterprise
Standard
Import data from ODBC, MS Excel, MS Access, DBF Enterprise
Standard
Export data to MS Excel, DBF Enterprise
Standard
Export data to MS Access (Windows Edition only) Enterprise
Standard
Structure and Data Manipulation
Structure synchronization Enterprise
Standard
Data transfer Enterprise
Standard
Data synchronization Enterprise
Standard
Data generation Enterprise
Standard
Data dictionary Enterprise
Standard
Copy and paste data across databases Enterprise
Standard
Backup and Restore
SQL Server Backup/Restore Enterprise
Standard
Dump/execute SQL file Enterprise
Standard
Automation
Set schedule on : query, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export Enterprise
Standard
Run profiles from different servers in a single batch job Enterprise
Standard
Include attachment for export file in notification email Enterprise
Standard
Server Security
Manage user Enterprise
Standard
Server monitor Enterprise
Standard
Other Useful Features
ER diagram view Enterprise
Standard
Open object via URI Enterprise
Standard
Virtual grouping Enterprise
Standard
Database wide search Enterprise
Standard
Favorites list Enterprise
Standard
Focus mode Enterprise
Standard
Dark mode Enterprise
Standard