Navicat Data Modeler2.1.21

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

12 April 2019

Database design tool.

Follow this app Developer website

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 Navicat Data Modeler

Version 2.1.21:

Minor bug fixes & stabilization.

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

2 Reviews of Navicat Data Modeler

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

(0)

Bub1200

16 June 2015

Version: 2.0.0

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

(0)

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

(0)