Navicat Data Modeler - design your database at Mac App Store analyse

***** Navicat Data Modeler is Finalist of 2016 DBTA Readers Choice “Best Data Modeling Solution *****

Navicat Data Modeler is a powerful and easy-to-use database design tool for creating and manipulating data models. It supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL and SQLite.

Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc.

With Navicat Data Modelers features, users can easily create high quality data models and understand database structures.

- Three types of data models: Conceptual, Logical, and Physical
A well-designed model increases both efficiency and data quality, and can be easily understood by a wide variety of audiences. Navicat Data Modeler 2.1 enhances communication and collaboration between business and information-technology professionals by providing the ability to design conceptual, logical, and physical models. You can draw your own shapes, lines and labels using the comprehensive range of drawing tools to enrich your model design.

- Reverse engineering
With the reverse engineering feature, you can create models from existing databases with just a few simple clicks. Using a step-by-step wizard, you can import existing database structures and create models from different sources such as MySQL, MariaDB, SQL Server, PostgreSQL, Oracle, SQLite, and even from an ODBC data source. The resulting models graphically show the structure of a database so that you can see and organize data elements, such as tables, views and relations without showing the actual data.

- Forward engineering
With the forward engineering feature, your visual data model can be transformed into a physical database on any servers supported by Navicat Data Modeler - MySQL, MariaDB, SQL Server, PostgreSQL, Oracle and SQLite. You can also compare your model with a live database to capture the differences in objects and properties, so that you can get a full analysis before expanding and upgrading your existing system. Additionally, you can export a model directly to DDL script to streamline the process of writing SQL statements.

- Navicat Cloud
Sync your models and virtual groups to the cloud so you can get real-time access to them anytime, anywhere. With Navicat Cloud Collaboration, you can create, organize and share files/projects with your coworkers from anywhere, on any device.

You can take control of your project -- adding members you choose, defining the role of each member, and get visibility into your team activities from the Activity Log to align your team for greater productivity.

Other useful features
- Crows Foot, IDEF1x and UML Notations
- Add Vertices, Layers, Images, Shapes and Notes/Labels
- Auto Layout
- Align/Distribute Objects
- Unlimited Undo/Redo
- Zoom in/Zoom out
- Model Conversion
- Full Screen Mode
- Virtual Grouping
- Search Filter

* For more detailed information, please visit:
http://www.navicat.com/products/navicat-data-modeler#mac

** For technical questions related to the Mac App Store, please visit:
https://help.navicat.com/hc/en-us

Update to the Yosemite OS X

• ★★★★☆   WebQuake 10 years ago ( v 1.0.5 )

The program is excellent. It works SUPER until I update OS X to the Yosemite. For example, the program crashes when I try to synchronize the design with the MYSQL database. It the reason I give my ratings to the four stars — it is rather the credit for the previous performance. I hope the vendor will fix the problem asap.

Brian McMillan

• ☆☆☆☆☆   brianmcmillan 9 years ago

This is an outstanding tool at a great price. I have been searching for a solid data modeling tool for a while now. As an independent consultant I was not ready to license any of the competitor products (costing between $1800 - $5500) so I struggled with basic drawing tools. I downloaded the evaluation version of the product from their web site and had it figured out in less than 15 minutes. In a matter of an hour or so I prototyped a conceptual model with a client, made revisions, and generated diagrams for review. Diagrams are easy to draw, crisp and professional looking, and look better than the diagrams from the more expensive tools. Both logical and physical models look great. Switching between modeling notations is simple. SQL generation for all the major databases is complete (tables, columns, indexes, FK’s, constraints ), fast, and accurate. Reverse engineering works extremely well. In short this is a great product. It is powerful, simple, and unencumbered by a bunch of stuff I don’t need. Five stars.

Read more App Reviews