CODEWITHSUNDEEP
sqlsql-serversql-server-2005
FarFigNewton
FarFigNewton

Reputation: 7273

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 will scan the database and give us a diagram that we can look at to help us do our jobs better.

Upvotes: 2

Views: 153

Answers (7)

David Atkinson
David Atkinson

Reputation: 5899

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.

Upvotes: 0

Andrew Lazarus
Andrew Lazarus

Reputation: 19292

I used Toad Data Modeler for a while.

Note: Windows only.

Upvotes: 0

Dean Kuga
Dean Kuga

Reputation: 12119

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.

Upvotes: 2

Femi
Femi

Reputation: 64700

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.

Upvotes: 2

Sai
Sai

Reputation: 3947

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.

Upvotes: 4

rafalotufo
rafalotufo

Reputation: 3932

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!

Upvotes: 2

Mike Veigel
Mike Veigel

Reputation: 3815

Enterprise Architect can do that.

Upvotes: 2

Related Questions