Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to get ERD of the database in Visio, but unsuccessfully. I tried reverse engineering option in Visio also, but unsuccessfully.

Did anyone do this already? How?

share|improve this question

closed as not a real question by Chris S, Scott Pack, Ward, MDMarra Jan 25 '12 at 20:01

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

I used some tool in the past capable of doing such thing I believe TOAD can do the same most probably it will not be as part of the standard clients provided by the database engine itself, however in third party you can find that – A.Rashad May 25 '10 at 10:13
I tried TOAD, although I did not have to (because I solved my problem). I like it a lot. Recommend for anyone who is bored with SQL Server Management Studio looks. Thanks for the tip – Eedoh May 25 '10 at 11:26

I did it using Visio 2010, at last. "Reverse Engineer" option in "Database" menu works after all. I was not creating datasource properly. I used "File Data Source" option, instead of "User Data Source" in New Data Source wizard.

share|improve this answer

I checked with a coworker, and she said SQL Management Studio does not provide the function of extracting ERD.

that means you have to use some third party application

share|improve this answer
Didn't have to, I succeeded with Visio, thanks anyway – Eedoh May 25 '10 at 11:26

Not the answer you're looking for? Browse other questions tagged or ask your own question.