question

Ira avatar image
Ira asked

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.

sql-server-2008t-sqldatabase-designexisting-tableer-diagram
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Jay Bonk avatar image
Jay Bonk answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image
TimothyAWiseman answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

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

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David 1 avatar image
David 1 answered

I use Sybase PowerDesigner or Visio.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

cliche avatar image
cliche answered

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

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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/
0 Likes 0 ·
Man avatar image
Man answered
1. Open SSMS, Look for you DB and expand it. 2. Opt 'DATABASE DIAGRAMS' and then 'NEW DATABASE DIAGRAM'. 3. You will get the popup listed all the tables of your DB, Select all / required tables to add in the diagram. 4. You are done..... Thanks Manish
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aa_dev avatar image
aa_dev answered
How to take these all details of the tables separately as a file incase i need to have a hard copy?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Best bets: 1. ask this as a separate question rather than as an answer to an existing ages-old question 2. Use the "Script" tool in SSMS. Right-click on the DB name, Tasks, Generate Scripts
0 Likes 0 ·
carterdunley avatar image
carterdunley answered
I know that Lucidchart works with Visio files and several different formats as well. It is free or a full feature trial account to see if it will work.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.