Navicat Data Modeler is a powerful and cost-effective database design tool which help users build high-quality logical and physical data models. It supports various database systems, including MySQL, Oracle, SQL Server, PostgreSQL and SQLite.
Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import models from ODBC data sources, generate complex SQL/DDL and print models to files, etc.
Navicat Data Modeler is available for three platforms – Microsoft Windows, Mac OS X and Linux. With Navicat Data Modeler's features, users can simplify the task of creation of complex entity relationship models and generate the script SQL with a simple click.
Features :
List of supported databases
- MySQL 3.21 or above *Support of Drizzle, OurDelta, Percona Server and MariaDB
- SQL Server 2000 or above and SQL Azure *Only available for Windows and Mac OS X Edition
- Oracle 8.1 or above *Mac OS X Edition starts from Oracle 8.1.7
- PostgreSQL 7.3 or above
- SQLite 2 and 3
|
|
Reverse Engineering
Reverse Engineering is one of the key features of Navicat Data Modeler. This feature allow you to load already existing database structures and create new ER diagrams. With the Reverse Engineer Wizard in Navicat Data Modeler, database models can be graphically visualized so you can see how database elements, such as attributes, relationships, indexes, uniques, comments and other objects depending on the particular database, relate to each other without showing the actual data. Navicat Data Modeler is able to use a number of different communication methods:
- Direct connection
- ODBC *Only available for Windows and Mac OS X Edition
- Navicat family
|
|
Comparison and Synchronization
Synchronize to Database feature will give you the full picture of all databases differences. Once your databases are compared, you can view the differences and generate the necessary synchronization script to update the destination database and make it identical to your model. Flexible comparison and synchronization settings will enable you to set up a customized comparison key for comparison and for synchronization.
|
SQL Code Generation
Navicat Data Modeler not only a tool to create ER diagrams and design your databases. Its Export SQL feature gives you the opportunity to get a full control over the final SQL script, generate individual parts of your model, generate referential integrity rules, comments, character set etc. The Export SQL feature may save you hundreds of hours of your work.
|
More Great Features
Standard Designing Tools Auto layout, add vertices, layers, images and notes/labels, align/distribute objects, unlimited undo/redo capability and more.
|
|
Search Filter If you want to narrow the list of tables displayed in Navicat Data Modeler, why don't you try our filtering feature. Type in text, and only those database objects that start with the specified string are highlighted.
|
System Requirements:
- Microsoft Windows XP SP2, Vista, Server 2003, Server 2008, Windows 7, Windows 8
- Pentium II processor or above
- Hard-disk space vary depending on installation. Full installation requires 65 MB of available hard-disk space