Nope..Open up Visio db diagram > Database > reverse engineer
It will ask for the data source and some other settings - can't remember off the top of my head what they are right now :) Then it will import the tables into the diagram with the relationships.
-----Original Message-----
From: Horton, Joe (LNI) [mailto:[Email Address Removed] Thursday, March 25, 2004 1:28 PM
To: LazyDBA.com Discussion
Subject: RE: Entity Relationship Diagram
But wouldn't I have to manually draw the relationships? I thought there
would be some tools out there to reverse engineer my DB.
__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200
-----Original Message-----
From: Kristina Carlton [mailto:[Email Address Removed]
Sent: Thursday, March 25, 2004 10:26 AM
To: Horton, Joe (LNI)
Subject: Re: Entity Relationship Diagram
Have you tried Visio Professional?
----- Original Message -----
From: "Horton, Joe (LNI)" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 25, 2004 12:17 PM
Subject: Entity Relationship Diagram
> I am tasked with printing a database diagram or ERD and am unsure the best
> tool to use to create it. I've been playing with the EM Diagram tool but
> can't seem to get it to show the entity relationships.
>
> Any suggestions of tools?
>
> __________________________
> Joe Horton
> Database Developer / Software Engineer
> WISHA/Legal Services Software Development
> Department of Labor and Industries
> Voice (360) 902-5928 fax (360) 902-6200
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page