INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

SQL 2005 Database Diagram in Visio 2003?

SQL 2005 Database Diagram in Visio 2003?

(OP)
ok, so I made a diagram in SQL 2005 database, but can't export to visio.  I made a diagram in visio, but don't have the right shapes for the tables so it is a completely manual representation of the database, and it isn't linked because I didn't know how to do that.

Microsoft online says you can reverse engineer a diagram in visio by going to new | database.  I go to new and database is not an option.  I have visio 2003.  

Can anyone please help me?  I tried to go to Tools | Add ins | and then the database wizard thing, but after it connects to the odbc it starts to have me pick 1 table and set it up.  I have like 40 tables.  I can't do them 1 by 1.  I really just want a wizard or something to grab the tables and relationships from the database and plop objects onto a Visio page.

Is this possible?  Can anyone please help me understand how I can do this?  I can figure some things out, but some may be over my head.  If so, there is always help!

misscrf

It is never too late to become what you could have been ~ George Eliot

RE: SQL 2005 Database Diagram in Visio 2003?

On the screen where you pick a table you should be able to select multiple tables at the same time.  Try holding down control and clicking on the tables.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

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!

Resources

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