Posted by Erland Sommarskog on 12/15/06 23:01

(sangu_rao@yahoo.co.in) writes:
> I have to prepare an ER diagram for the objects in my SQL Server
> database. I have used the option "DIAGRAMS" in EnterPrise Manager of
> SQL Server 2000. It is creating the diagram for the selected tables
> (but the diagram contains only the table which i have selected. It is
> not displaying its depended tables).

The table-selection dialog has a checkbox that permits you to specify
that related tables should be included. There is also a field that
specify how many levels deep related tables should be picked up.

> But i am not able to export it to any of the flat file like MS WORD or
> paint. I want this diagram to be uploaded to one Flat file and send to
> my customer for his reference. Could anyone suggest me how to create the
> ER Diagram for the SQL 2000 database and export it to a flat file.

That does not seem to be an available feature.

What you can do is to set up a printer that prints to a FILE device. For
the printer driver, you would select a printer that your client can print
to. Or, a printer driver that produces a format that can be opened with
some Windows program.

The diagram functionality in Enterprise Manager is very low-key. If you
want a serious data-modelling tool, look at PowerDesigner, Embrocadero
or ERwin.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]