Feature Matrix
| Lite | Enterprise | |
| Workspace | ||
| Model conversion - conceptual, logical and physical | ||
| Model methods - relational, dimensional and data vault 2.0 | ||
| Build multiple models and diagrams in one workspace | ||
| Multiple diagram editing | ||
| Compare model workspaces | ||
| Focus mode | ||
| Present mode | ||
| Dark mode | ||
| Model | ||
| Create/edit/drop database objects and relations | ||
| Code completion | ||
| Code snippet | ||
| SQL beautifier | ||
| View builder | ||
| Diagram | ||
| Crow's Foot, IDEF1x and UML notations | ||
| Auto layout | ||
| Zoom in/zoom out | ||
| Lock/group elements | ||
| Connector line | ||
| Aligning and distributing database objects | ||
| Add vertices, layers, images, notes, labels and shapes | ||
| Copying SQL from diagram objects | ||
| Reverse/Forward Engineering | ||
| Secure connection: SSH, HTTP Tunnel and SSL/TLS | ||
| PAM authentication | ||
| LDAP authentication | ||
| Kerberos authentication | ||
| Import from cloud database: Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Alibaba Cloud, Tencent Cloud, Huawei Cloud | ||
| Import tables from ODBC | ||
| Import connections from Navicat family | ||
| Centralized connection management | ||
| Reverse database to model | ||
| Synchronize database to model | ||
| Synchronize model to database | ||
| Export model to SQL/script file | ||
| Navicat Collaboration | ||
| Collaboration: create projects, add members | ||
| Synchronize connection settings | ||
| Synchronize model workspaces and virtual group information | ||
| Other Useful Features | ||
| Data dictionary | ||
| Open object via URI | ||
| Search filter | ||
| Print database diagrams to PDF and graphic files |
Workspace
| Model conversion - conceptual, logical and physical |
Enterprise Lite |
| Model methods - relational, dimensional and data vault 2.0 |
Enterprise Lite |
| Build multiple models and diagrams in one workspace |
Enterprise Lite |
| Multiple diagram editing |
Enterprise Lite |
| Compare model workspaces |
Enterprise |
| Focus mode |
Enterprise |
| Present mode |
Enterprise Lite |
| Dark mode |
Enterprise Lite |
Model
| Create/edit/drop database objects and relations |
Enterprise Lite |
| Code completion |
Enterprise Lite |
| Code snippet |
Enterprise Lite |
| SQL beautifier |
Enterprise Lite |
| View builder |
Enterprise |
Diagram
| Crow's Foot, IDEF1x and UML notations |
Enterprise Lite |
| Auto layout |
Enterprise |
| Zoom in/zoom out |
Enterprise Lite |
| Lock/group elements |
Enterprise Lite |
| Connector line |
Enterprise Lite |
| Aligning and distributing database objects |
Enterprise Lite |
| Add vertices, layers, images, notes, labels and shapes |
Enterprise Lite |
| Copying SQL from diagram objects |
Enterprise |
Reverse/Forward Engineering
| Secure connection: SSH, HTTP Tunnel and SSL/TLS |
Enterprise |
| PAM authentication |
Enterprise |
| LDAP authentication |
Enterprise |
| Kerberos authentication |
Enterprise |
| Import from cloud database: Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Alibaba Cloud, Tencent Cloud, Huawei Cloud |
Enterprise |
| Import tables from ODBC |
Enterprise |
| Import connections from Navicat family |
Enterprise |
| Centralized connection management |
Enterprise |
| Reverse database to model |
Enterprise |
| Synchronize database to model |
Enterprise |
| Synchronize model to database |
Enterprise |
| Export model to SQL/script file |
Enterprise |
Navicat Collaboration
| Collaboration: create projects, add members |
Enterprise Lite |
| Synchronize connection settings |
Enterprise |
| Synchronize model workspaces and virtual group information |
Enterprise Lite |
Other Useful Features
| Data dictionary |
Enterprise |
| Open object via URI |
Enterprise Lite |
| Search filter |
Enterprise Lite |
| Print database diagrams to PDF and graphic files |
Enterprise Lite |

