tags:

views:

15

answers:

1
Q: 

SQL Server Entity-Relationship Model generation

What's the best tool to reverse engineer an SQL Server 2005 to an entity-relationship Model diagram? Could it be done usin SSMS?

A: 

Do you need more than the Database Diagram functionality provided in each database in SSMS? This will generate a diagram with any tables you choose and any relationships that are defined.

I've also used Visio which is useful if you have a large number of tables and need more control over the diagram.

Paul Spangle  2010-09-23 14:22:46
I was actually not aware of the Database Diagram, which worked fine!
Rodrigo Gama  2010-09-29 11:28:30

related questions

Is there a way to script diagrams in SQL 2000 (or save them another way)?
Distributed System Diagramming Best Practices?
Sprint Cumulative Flow Diagram
Who uses a digital notepad for saving UML and other diagrams?
WPF Diagramming Library
Good tool for drawing SCM code branch diagrams
Loading an existing database into WWW SQL Designer?
Decipher database schema
Compartment items not displayed in DSL diagram
Good tool to generate dependency diagram?
How do I reference a diagram in a DSL T4 template?
Recommended Eclipse plugins to generate UML from Java code
Which tool do you use to draw simple diagrams/pictures to illustrate a technical point?
Which tool do I use if I want to map a programming framework visually and see the relationship between all entities?
Is there a good WPF diagrammer / toolkit / provider ?
Diagramming Software for a Developer/Designer
Open 2 Visio diagrams in different windows
Database Schema Diagram Design Tool
Suitable E-R notation for introductory DB design course? Good/free diagram tools?
Is UML practical?
VS.NET Application Diagrams
Entity diagrams in ASP.NET MVC
What's the best UML diagramming tool?
What program can I use to generate diagrams of SQL view/table structure?
Auto Generate Database Diagram MySQL