Menu
I am trying to generate the ER diagram using Mysql workbench in ubuntu.
The database contains 755 Tables
And the Error message
Too many objects are selected for auto placement. Select fewer elements to create the EER diagram.
Is there any possibility to avoid this error and continue to create Reverse Engineering for all the 755 tables at one shot
593
In the menu, Go to Model >> "Diagram properties and size". Then in the menu, Go to Arrange >> Autolayout.
If your script creates a database, MySQL Workbench creates a new Physical Schemas area within the open MySQL Model tab. Click Execute to reverse-engineer the SQL script, verify its results, and optionally place the objects in a new EER diagram. The next figure shows an example of the finished operation.
To generate a script from a diagram in MySQL Workbench: Select File > Export > Forward Engineer SQL CREATE Script... Enter a location to save the file (optional) and set options to include on the script (such as DROP statements etc), then click Continue.
Select Preferences from the Edit menu to configure MySQL Workbench to your specific needs. The Workbench Preferences sidebar menu is divided into the following sections: General Editors: General-purpose editor options, such as SQL parsing options.
Workbench emits that "Resource Warning" error and then deselects the "Place imported objects on a diagram" option for you. Execute it again (click "Execute") without that option to execute the Reverse Engineering wizard. Then, create a new EER diagram, select all tables (objects) using the "Catalog" tab on the left pane, and then drag them onto the EER diagram canvas. This will take a few minutes or so to execute. When finished, optionally select "Autolayout" from the "Arrange" navigation menu and then wait another few minutes.
I just tested this with 2000 tables and it works.
146
By following the @Philip Olson Instruction it resolves my problem, the tables are overlapping due to a large number of tables available in the database with relationships.
I came up with the soliton to tackle this problem :
1 - Click on Database > Reverse Engineer
2 - Fillup the connection info > Click on Next
3 - I should complete the all three execution as shown in the below snapshot: Click on Next
4 - Select your database and click on Next
5 - It should again complete the all execution as shown in the snap shot if passed click on Next
6 - On the next screen on Select Object to Reverse Engineer uncheck Place imported objects on a diagram if you have large number tables present in your database as shown in the below screen shot and then click on next. Then next screen should satisfy only first parameter.
7 - Go to EER Diagram Tab, On the left side you will see a tab call Catalog Tree. Select your database, open a tables tranche, select all the tables present under the respective database, and drag and drop on the right hand side diagram board. Now doing this it will create a diagram cluttered like your tables will overlapped on to the another table.
8 - Now go to the Model > Diagram Properties and Size > Select the size of the Diagram from the bottom. As shown in the snap shot below.
9 - Now go to the Arrange menu click on Auto Layout TADA. Your EER Diagram with proper alignment is ready for you.
43
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
