Name: Navicat Data Modeler
Price: 349.00 $
Rating: 2.75 (2 reviews)

Navicat Data Modeler overview

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 two platforms: Microsoft Windows and Mac OS X. 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.

What’s new in version 2.1.21

Updated on Apr 12 2019

Version 2.1.21:

Minor bug fixes & stabilization.

Information

License

Shareware

Size

147 MB

Developer’s website

http://www.navicat.com/products/navicat-data-modeler

Downloads

3201

App requirements

Intel 64
OS X 10.9.0 or later

0.0

(0 Reviews of )

There are no reviews yet

Bk1200

Jun 16 2015

2.0.0

0.0

Jun 16 2015

0.0

Version: 2.0.0

I'm not quite sure why there is a $79 price tag here. Navicat Customer Center prices it $249!

ming-deng

Dec 8 2014

1.0.6

0.5

Dec 8 2014

0.5

Version: 1.0.6

I tried navicat data modeler to export SQL statements for table creation for PostgreSQL and for SQL server. The output is unusable. For PostgreSQL it creates "Create Index.." which is not supported by PostgreSQL. For SQL server it generates "Drop constraint w/o name" which is going to fail in the SQL server. Also stupid enough it tries to drop all the indices before dropping a table! When drop a table all indices got drop all together why generate tons of dropping index statements? The tool has nice GUI but at this point it seems useless and is full of bugs! Below are few statements generated for SQL server: ALTER TABLE [line_items]DROP CONSTRAINT [] GO ALTER TABLE [orders]DROP CONSTRAINT [] GO