473,233 Members | 1,553 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 software developers and data experts.

How to create the ER Diagram for SQL Server Database objects

Hi,
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). 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.
Thanks for your help in advance.

-Rao

Dec 15 '06 #1
2 51929
(sa*******@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 15 '06 #2
Uzytkownik "Erland Sommarskog" <es****@sommarskog.senapisal w wiadomosci
>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
I have just imported my database to Visio! I cannot say, if you should like
the effect, for my needs it was not so bad. After you try this your client
may use Visio, otherwise Visio offers saving file as .jpg or webpage ..(I
had no need to do so so far, but why not to try.)

Visioo offers you to choose db driver (exact one or generic ODBC), and you
can select entire db to be created, or selected elements. (If you have more
detailed questions on doing so - you're welcome to ask).
ps:
One problem pending is to provide planar graph layout of my diagrams. (Any
tool I know (i.e. RaRose) don't support this feature really acceptable:
althrough they produce planar graphs, it's still not enough user - friendly.

Did this help a bit....?
Dec 29 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mark Huebner | last post by:
I have Visual Studio 2003 Professional and MS SQL Server 2000 installed on my laptop. For some reason, I can't create a new database with the Visual Studio Server Explorer. The error message is...
3
by: Parham | last post by:
Hello, How to protect structures(Tables,SP,Views and Functions) of a SQL Server Database?(Password protect a database file) I have a SQL database that will distribute with my application, I want...
1
by: Paul | last post by:
Hi, I wish to be able to add tables to a sql server database at runtime from my asp.net application. As well as creating fields I also wish to be able to create indexes on selected fields and to...
2
by: Rob Richardson | last post by:
Greetings! It seems to me that there is room for a lot of improvement in automatic generation of database objects. If I create a data adapter from a table shown in the Server Explorer, I get...
3
by: teedilo | last post by:
Our MS SQL (SQL Server 2000) DBA has database privileges locked down pretty tightly. We end users/developers do not have administrator privileges for most databases. That arrangement has worked...
2
by: d.grabov | last post by:
We are trying to use source control to store our database objects and queries in Perforce. The general idea is to produce scripts which create all objects in the DB and then store the SQL in source...
9
by: TC | last post by:
Like a lot of database developers, I often choose Jet for the back- end. I'm starting to worry about what will happen when Jet is deprecated. Ostensibly, Jet users like me must switch to SQL Server...
0
by: VVRNB | last post by:
I would like to know how to develop Client server program in Visual Basic 6 with Ms Access database. I do not know how to write code for client and Server . How to prepare activex DLL. A simple...
4
by: MartinJackson | last post by:
Using SQL Server 2005 Express. I want to create and maintain the SQL database and tables from within a VB6 application. First I need to create an empty database file. This I can't do. Using...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.