database diagrams sql 2000

Hi People,
what tool/how do I generate database diagrams/schematics for a sql 2000 Database?
I need to see tables, relationships etc.
I only have Enterprise Manager at present.
thank you.

NJS,

Using Enterprise Manager, expand your database details, select the Diagrams
entry, right-click, choose New Database Diagram... and go to work.

Bad news is that this diagram is not particulary printable. If you also have
Visio or some such simple diagramming tool, you will probably have a better
experience in creating diagrams and printing copies for other people to use.
Although, it would be strictly offline from the database.

RLF

"NJS" wrote in message
news:37597DBB-36AE-493E-9B4D-557EF8DD40F7-at-microsoft.com...
> Hi People,
> what tool/how do I generate database diagrams/schematics for a sql 2000
> Database?
> I need to see tables, relationships etc.
> I only have Enterprise Manager at present.
> thank you.

Thanks Russel,
Maybe I should have mentioned this first, but I tried that before I posted
the question (as there are more than 80 tables the output is almost useless).
I was actually looking for a 'useful' / third-party automatic, zoomable,
sectionable schematic generator, that has the smarts to lay out the tables,
and indicate relationships. Do you know of anything?
cheers.

"Russell Fields" wrote:

> NJS,
>
> Using Enterprise Manager, expand your database details, select the Diagrams
> entry, right-click, choose New Database Diagram... and go to work.
>
> Bad news is that this diagram is not particulary printable. If you also have
> Visio or some such simple diagramming tool, you will probably have a better
> experience in creating diagrams and printing copies for other people to use.
> Although, it would be strictly offline from the database.
>
> RLF
>
> "NJS" wrote in message
> news:37597DBB-36AE-493E-9B4D-557EF8DD40F7-at-microsoft.com...
> > Hi People,
> > what tool/how do I generate database diagrams/schematics for a sql 2000
> > Database?
> > I need to see tables, relationships etc.
> > I only have Enterprise Manager at present.
> > thank you.
>
>
>

NJS,

Sorry, I did not understand your intent. There are several that you can
check out for free, to see if they meet you needs and your price points.

www.SmartDraw.com
www.Embarcadero.com
http://www.quest.com/Toad-Data-Modeler/
http://www.conceptdraw.com/en/produc...er_diagram.php
http://www.freedownloadmanager.org/d...gram_software/

Et cetera.

I used to use ErWin and have used Visio as well in an earlier incarnation.

RLF


"NJS" wrote in message
news:6930D7B2-0531-474C-8B04-C46DE98038CA-at-microsoft.com...
> Thanks Russel,
> Maybe I should have mentioned this first, but I tried that before I posted
> the question (as there are more than 80 tables the output is almost
> useless).
> I was actually looking for a 'useful' / third-party automatic, zoomable,
> sectionable schematic generator, that has the smarts to lay out the
> tables,
> and indicate relationships. Do you know of anything?
> cheers.
>
> "Russell Fields" wrote:
>
>> NJS,
>>
>> Using Enterprise Manager, expand your database details, select the
>> Diagrams
>> entry, right-click, choose New Database Diagram... and go to work.
>>
>> Bad news is that this diagram is not particulary printable. If you also
>> have
>> Visio or some such simple diagramming tool, you will probably have a
>> better
>> experience in creating diagrams and printing copies for other people to
>> use.
>> Although, it would be strictly offline from the database.
>>
>> RLF
>>
>> "NJS" wrote in message
>> news:37597DBB-36AE-493E-9B4D-557EF8DD40F7-at-microsoft.com...
>> > Hi People,
>> > what tool/how do I generate database diagrams/schematics for a sql 2000
>> > Database?
>> > I need to see tables, relationships etc.
>> > I only have Enterprise Manager at present.
>> > thank you.
>>
>>
>>

Thanks very much - cheers.

"Russell Fields" wrote:

> NJS,
>
> Sorry, I did not understand your intent. There are several that you can
> check out for free, to see if they meet you needs and your price points.
>
> www.SmartDraw.com
> www.Embarcadero.com
> http://www.quest.com/Toad-Data-Modeler/
> http://www.conceptdraw.com/en/produc...er_diagram.php
> http://www.freedownloadmanager.org/d...gram_software/
>
> Et cetera.
>
> I used to use ErWin and have used Visio as well in an earlier incarnation.
>
> RLF
>
>
> "NJS" wrote in message
> news:6930D7B2-0531-474C-8B04-C46DE98038CA-at-microsoft.com...
> > Thanks Russel,
> > Maybe I should have mentioned this first, but I tried that before I posted
> > the question (as there are more than 80 tables the output is almost
> > useless).
> > I was actually looking for a 'useful' / third-party automatic, zoomable,
> > sectionable schematic generator, that has the smarts to lay out the
> > tables,
> > and indicate relationships. Do you know of anything?
> > cheers.
> >
> > "Russell Fields" wrote:
> >
> >> NJS,
> >>
> >> Using Enterprise Manager, expand your database details, select the
> >> Diagrams
> >> entry, right-click, choose New Database Diagram... and go to work.
> >>
> >> Bad news is that this diagram is not particulary printable. If you also
> >> have
> >> Visio or some such simple diagramming tool, you will probably have a
> >> better
> >> experience in creating diagrams and printing copies for other people to
> >> use.
> >> Although, it would be strictly offline from the database.
> >>
> >> RLF
> >>
> >> "NJS" wrote in message
> >> news:37597DBB-36AE-493E-9B4D-557EF8DD40F7-at-microsoft.com...
> >> > Hi People,
> >> > what tool/how do I generate database diagrams/schematics for a sql 2000
> >> > Database?
> >> > I need to see tables, relationships etc.
> >> > I only have Enterprise Manager at present.
> >> > thank you.
> >>
> >>
> >>
>
>
>