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.

asked Nov 18 '09 at 09:57 PM in Default

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 '09 at 04:14 PM Ira

(comments are locked)

7 answers:

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

answered Nov 18 '09 at 10:14 PM

Jay Bonk
1.4k ● 2

(comments are locked)

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.

answered Nov 18 '09 at 10:03 PM

TimothyAWiseman
14.3k ● 17 ● 20 ● 29

(comments are locked)

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

answered Nov 18 '09 at 10:20 PM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

(comments are locked)

I use Sybase PowerDesigner or Visio.

answered Nov 19 '09 at 03:49 AM

David 1
1.8k ● 1 ● 3

(comments are locked)

How to take these all details of the tables separately as a file incase i need to have a hard copy?

answered Jan 21 at 07:58 AM

aa_dev
0

Best bets:

ask this as a separate question rather than as an answer to an existing ages-old question
Use the "Script" tool in SSMS. Right-click on the DB name, Tasks, Generate Scripts

Jan 21 at 09:17 AM ThomasRushton ♦

(comments are locked)