x

Entity RelationShip Diagram

Does anyone know of an automated way of creating an ERD from an existing MS SQL 2008 Database? I've been tasked recently with supporting a third party tool and need more info on the back end. Any help is appreciated.

more ▼

asked Nov 18, 2009 at 09:57 PM in Default

Ira gravatar image

Ira
26 1 1 1

Thanks for all the suggestions. I'm thinking I'll try putting a python script together that dumps to xml queries on information schema views. Failing that, I'll probably try out DeZign for Databases which was mentioned in the StackOverflow question. One of the db admins here also recommends it.
Nov 20, 2009 at 04:14 PM Ira
(comments are locked)
10|1200 characters needed characters left

8 answers: sort oldest

I use ModelRight as a modeling tool, while SSMS as pointed out by Tim will get you started. I think that you can get a 30 day trial on ModelRight, and probably any number of other modeling tools.

Some others are mentioned here: http://stackoverflow.com/questions/419276/data-modeling-tool-for-sql-server

more ▼

answered Nov 18, 2009 at 10:14 PM

Jay Bonk gravatar image

Jay Bonk
1.4k 2

(comments are locked)
10|1200 characters needed characters left

It is not a proper ERD, but you can come close using the database diagram tool available in SSMS. You can certainly use that as a starting point to tweak into a true ERD.

more ▼

answered Nov 18, 2009 at 10:03 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.5k 20 23 32

(comments are locked)
10|1200 characters needed characters left

If you have access to visio, you can generate an erd directly from schema with that...

more ▼

answered Nov 18, 2009 at 10:20 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left

I use Sybase PowerDesigner or Visio.

more ▼

answered Nov 19, 2009 at 03:49 AM

David 1 gravatar image

David 1
1.8k 1 3

(comments are locked)
10|1200 characters needed characters left

how to do? I have an existing database in MS SQL SERVER 2008.. I want to generate an ERD from my existing database. How to do? pls help

more ▼

answered Jun 05, 2010 at 10:34 AM

cliche gravatar image

cliche
1

Use tools like ERstudio to reverse engineer the diagram from the database. Also You can also try this opensource DB designer http://sourceforge.net/projects/dbdesigner-fork/
Jun 07, 2010 at 03:06 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1834
x985
x107
x7
x1

asked: Nov 18, 2009 at 09:57 PM

Seen: 14797 times

Last Updated: Jun 23 at 11:00 PM