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 |

