What GOOD tools are available for generating ERD from a SQL Server Database?

Question

I am trying to generate an Entity Relationship Diagram from an existing MS SQLServer 2005 database. What tools are available? Specifically,I am not only interested in ERD's more directly I am looking for a tool to help quickly learning and analysing a medium size (schema wise not really row wise) database structure.

Answer 1

The database reverse engineering feature of microsoft Visio are excellent for pulling the schema out of a database and developing from there. I'd investigate that avenue if you haven't already.

Answer 2

I've used Visio and had some good results with that. One thing I do though too is to use the visual designers (Database Diagrams) built into SQL Server GUI. When you drop the tables in there, it automatically includes the foreign keys. You can just include the tables you want at this point to focus in.

All of these tools though anticipate the foreign keys pre-existing.

Answer 3

Take a look at this question.

Answer 4

I've been happy with DBDesigner4.

Answer 5

You can also generate an ERD from Microsoft Visual Studio 2005.