Home » Questions » Computers [ Ask a new question ]

Tool for automatically generating and laying out an entity relationship diagram?

Tool for automatically generating and laying out an entity relationship diagram?

I've seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven't been able to find one which is capable of automatically laying out the diagram in a reasonable way. Most of them just plop all the entities down on top of each other and call it a day. Some make an attempt at organizing the entities, but they don't do a very good job of it.

Asked by: Guest | Views: 143
Total answers/comments: 2
Guest [Entry]

As long as you've got foreign keys in your database I've found that Visio does a pretty good job. I had a postgresql database with about 150 tables from four different merged projects that were connected through various foreign keys and it did an awesome job of extracting all the relationships and grouping the tables together. The diagram had only a few overlapping lines despite extensive foreign keys. Also, because of the foreign keys logical elements were grouped together nicely it was clear which databases most of the tables originated in.
Guest [Entry]

DBeaver has the ability to view database structure as an entity relation diagram.