Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
    
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
add comment

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.

2 Answers

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
add comment

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
add comment

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