Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reverse Engineer SQL2005, Visio 2007

Reverse Engineer SQL2005, Visio 2007

Reverse Engineer SQL2005, Visio 2007

Morning Guys,

I'm pretty new to visio, Only been playing around for about a week or so now on the trial edition of 2007 which I downloaded, I've so far been pretty impressed, worked on a couple of database concepts and things like that.

I've got a database sat on my remote SQL2005 server and I'd love to have it all plotted nicely with diagrams right here beside me whilst developing my application, as trying to picture the damn thing in my head is a total nightmare lol. Will visio allow me to do this? I gather that this is what the reverse engineering tool is for? Is that right?

I need some really simple step-by-step style instructions on how to achieve this, I did take a couple of shots at it but to be honest, the list of different drivers and datasource types became a little overwhelming and I didnt really know what was my best route.

Also, how complex can the diagrams be made? It would be great If i could see the datatypes of every column directly on the printed diagram, this is somthing I'm yet to figure out.

Can anyone offer some advice on this stuff?

Thanks guys, look forward to talking with you.


RE: Reverse Engineer SQL2005, Visio 2007

Update guys,

I've managed to get my connection to the server now and its pulling everything down very nicely, but my diagrams still lack the amount of detail i'd like to see on them. They list all the column names, keys and lines for the relationships, but no detail on the columns themselves, like datatype, length and so forth, which are all quite important attributes.

Any idea if I can display those on the chart?



RE: Reverse Engineer SQL2005, Visio 2007


Did you manage to figure out the datatype thingy?

I've just started playing around with Visio 2007 this yesterday!  Datatypes can be displayed by selecting "Database" from your menu.  Then select "Options" and then "Document".  Under the "Table" tab you can select what details to view including the datatypes.

Hope it helps.


RE: Reverse Engineer SQL2005, Visio 2007

Thanks Neemi,

I hadnt figured that out, your advice was a great help, thanks mate.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close