Navicat Data Modeler is a powerful and cost-effective database design tool which helps you 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 you 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.
With Navicat Data Modeler features, you can simplify the task of creation of complex entity relationship models and generate the script SQL with a simple click.
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 is one of the key features of Navicat Data Modeler. This feature allows 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.
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.
Microsoft Windows XP SP2, Vista, Windows 7, Windows 8, Server 2003, Server 2008, Server 2012
Home Page - http://www.navicat.com/