Free database modeling tools

Document directory

• Here are some useful tools:

Here are some useful tools: First: erdesigner ng
Official website is: http://mogwai.sourceforge.net /? Welcome: erdesigner_ng
An open-source product of SourceForge. The current version is 1.4.
The following are official descriptions:
Program code
The mogwai erdesigner is a entity relation modeling tool such as Erwin and Co. the only difference is that it is open source and does not cost anything. it was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation. this tool was also designed to support a flexible plug in architecture, to extend the system simply by installing a new plug in. this way, everybody can implement new features and tools to make erdesigner fit the requirements. erdesigner ng

* Is based on Java and can be run on Windows and Unix systems
* Has A powerfull WYSIWYG for physical database design
* Handles tables, relations, indexes and comments
* Supports subject areas
* Supports MySQL, Oracle, Microsoft sqlserver and Postgres
* Creates the SQL DDL statements for Schema Creation
* Has an integrated schema version control system
* Can generate schema migration scripts for every change
* Stores the database definition as XML files for further processing
* Can export the database schema as GIF, BMP, JPEG or SVG files
* Has an integrated reverse engineering module for existing Schemas
* It is based on GPL license
* Support is available by authors and newsgroups

From the above description, we can see that the software supports a variety of mainstream databases, such as MySQL, Oracle, and MSSQLServer.
Functions Support reverse engineering, database comparison, automatic DDL generation through modeling, and model graph conversion into images.
The software is as follows:

Second: modelright3
Official Website: http://www.modelright.com/Default.aspx
The following is an official introduction:

Program code
Need to design, visualize or document your database?
Modelright 3 can reverse engineer your existing database to give you a graphical view of it, generate all the SQL statements to create the database, or synchronize your database model with the database to keep your design up to date.

Do you need to control the most detailed aspects of your database?
Modelright 3 has more complete and in-depth support for your database's (Oracle, SQL Server, MySQL or any via ODBC) most advanced features.

Don't think it really supports so many databases. This is the Professional Edition, so much knowledge. If you call it a lot of money, you can buy the Professional Edition!
This product is more professional than erdesigner ng for a simple reason. It is a commercial tool. However, there is also a free version, it's just that free copyrights are much less supported by databases! Today we are introducing this free version, which only supports MySQL, which is quite painful! Real estate providers are not very generous!
Next image!

Another official image (Professional Edition)

Do not be jealous of the Professional Edition. You have to pay for it! If every one of us has a lot of money, how nice it is!

Third, opensystemeffecect (recommended products)
Official Website: http://www.codebydesign.com/
This is a completely open-source product and is recommended for use.
My favorite point is that the Operation habits are a bit similar to powerdesigner, and the interface is a little ugly than PD, but it is quite useful!
It supports Windows and Linux
The following is an official introduction:

Program code
Open System effecect (OSA) is an application used for modelling a system. osa currently supports data modelling (physical and logical) with UML in the works. the unique thing about OSA is that it is an open source product licensed under the General Public License (GPL ). the free factor makes OSA maid for students but OSA is powerful enough to compare favourably with products costing thousands of dollars.

OSA is already sored by codebydesign (the originally developer of OSA) and by Source Forge (they host the Community Collaboration Environment for OSA ).

The following is an official demo. After reading this, I believe you will download it soon! Why is it true!
Logical Model

Physical Model

SQL Editor

Fourth: MySQL workbench
Http://dev.mysql.com/workbench/
MySQL official design tool, for MySQL
If you are using MySQL, you can also consider it!

Reference: http://xiaodaoma.blog.ccidnet.com/home.php? MoD = Space & uid = 62827 & Do = Blog & id = 20595380