Is there a program that will display a SQL schema diagram from an existing database?

We have a giant big ass database and we can't visualize it. Is there a program that wi开发者_运维知识库ll scan the database and give us a diagram that we can look at to help us do our jobs better.

---

I haven't tried it but you can take a look at ... http://office.microsoft.com/en-us/visio-help/reverse-engineer-an-existing-database-into-a-database-model-HA010115485.aspx

You will need Visio though for it.

---

Enterprise Architect can do that.

---

I once used http://schemaspy.sourceforge.net/ to do that for a MSSQL database. It is pretty good, generates html pages so you can browse. Try it out!

---

You might want to look at Db Visualizer: the free version will give render Entity Relationship Diagrams for you, and works with any database that has a JDBC driver.

---

In SQL Server Management Studio there is a 'Database Diagrams' node. Right click on it and choose 'New Database Diagram'. Select tables you want in your diagram and SSMS will generate it for you.

---

I used Toad Data Modeler for a while.

Note: Windows only.

---

You could try SQL Dependency Tracker, which is developed by the company I work for. However, if you intend to visualize the entire database on one small screen, it might be tough. Consider breaking down your database into logical segments and visualize these individually.