MySQL Workbench - schema change scheme - autostart does not work

Question

I am using MySQl Work-bench 2 to build a chart diagram. by reverse engineering the database. However, when I included 450 tables ., The tables overlap with each other and are practically impossible for me. To change because there is no room.

The arrange option in the Mysql work-bench also doesn't help much. Is there any tool on the Internet that can also change. Or I just need to make a method of separation and conquest. that is, to partially select part of the tables and design part of the diagram in parts.

Answer 1

I am using Mysql Workbench 6.1. By default, the chart will look crunchy for a large number of tables, which makes it difficult to determine the relationship between the tables. Many tables will overlap with other tables. This is because the default layout size is small.

From the menu, select "→" Properties and Size Chart ".

Change the width and size to some larger one (e.g. width 23 and height 5) -

Then, in the menu, select "Arrange → Self-timer."

Now we should see a clean diagram with all relationships. Now we can more accurately change the width and height

Answer 2

As a rule, you can look at 450 tables at the same time. In many schemas, tables are related by function. For example, for a schema representing a repository, there may be customers, orders, products, etc. The product itself may consist of a number of related tables. You can use a tool like SchemaCrawler to understand such a scheme. SchemaCrawler allows you to search for column and table names using regular expressions. Then you can add related tables. Finally, you can graphically display the selected tables. All this can be done with a single command line. If your layout changes, just save the command and try again. SchemaCrawler is free and open source.

Sualeh Fatehi, SchemaCrawler