6 years ago (2015-05-21)  Technical application |   First to comment  1818 
post score 0 times, average 0.0

Navicat guests used personal data in the database learning process to think of the best database connectivity, design, and editing software.It is not only the most beautiful interface in the database software used by the very guests, but also the most powerful and simple to operate. Navicat has for MySQL, for MariaDB, for SQL Server, for SQLite, and for Oracle. For multiple single database versions such as PostgreSQL, and also a comprehensive version of Navicat Premium, Navicat Premium is a multi-connected database management tool that allows you to connect to MySQL, MariaDB, SQL Server, SQLite, Oracle and The PostgreSQL database supports most of the functions used in today's database management systems, including stored procedures, events, triggers, functions, views, etc. At the same time, users can be added to the database to set permissions. Extreme users use Navicat in addition to the above common features, but also use navicat for database data backup, synchronization, Wang Baiyuan's blog on the virtual machine database data backup, synchronized to the local, or use navicat to move the site.I mainly introduce how to use Navicat to make ER diagrams and interconvert with SQL: export database tables into ER diagrams and export ER diagrams into SQL statements (this feature is also extremely unintentional for guests, just learning, welcome to share!).

First, make ER diagram with Navicat

  Open the navicat "model" - "new model" navicat make ER diagram  

Second, export the ER diagram as a SQL statement

[Caption id="attachment_1215" align="aligncenter" width="698"] Navicat export to ER diagram as SQL [/caption] Open tool - export SQL This way as long as the design ER diagram, all the table construction statement, Including the primary key, foreign key relationship, Navicat will automatically generate for us.

Third, the existing database is converted to ER diagram

Select the data table in the connected database - Right click and select "Inverse Database to Model" to generate an ER diagram model from an existing database.  


This article has been printed on copyright and is protected by copyright laws. It must not be reproduced without permission.If you need to reprint, please contact the author or visit the copyright to obtain the authorization. If you feel that this article is useful to you, you can click the "Sponsoring Author" below to call the author!

Reprinted Note Source: Baiyuan's Blog>>https://wangbaiyuan.cn/en/sql-and-use-navicat-to-make-er-diagram-and-interactive-2.html

Post comment


No Comment


Forget password?