473,703 Members | 3,032 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 51985
(sa*******@yaho o.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****@sommarsk og.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****@sommars kog.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
2435
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 "Cannot create databases on this server". I made sure I started up my instance of SQL Server called T30-THINKPAD so it is running. However, I can create (and delete) databases with the Enterprise Manager. The views from Server Explorer and...
3
13998
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 to protects it's structure from my appliction users. Only my application can access the database. Thanks
1
1804
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 assign user permissions. (I need to assign permissions to the table object as I will be using sp_executesql or exec to execute a string). I'm thinking there are 3 possible ways to do this:
2
1537
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 Select, Insert, Update, and Delete commands, not all of which may be necessary. I don't have any control over command names or parameter names. If all I am going to be doing is inserting data into a table, I don't even need a data adapter. All I...
3
10689
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 out OK for the most part. However, it's a bit aggravating that we can't even create our own database diagrams. When we attempt to do so (in Enterprise Manager), we get a dialog that says "You do not have sufficient privilege to create a new...
2
3187
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 control. Has anyone done this before and can suggest some advice? Alternatively if anyone has other methods for using source control on a database, could you please let me know? Also, is there any automated way of extracting individual scripts...
9
3007
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 (or MSDE / SQL Express), but there's something I just don't understand. Without Jet, how will we create file server database applications? In other words, how will we create multi-user apps which use a file server to share data and don't...
0
2231
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 example will do with atleast 2 to 3 fields like ID, Name , desg . But the main purpose is I want it to be shared in Other Computers connected in LAN in my office
4
9221
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 Set mcn = New ADODB.Connection mcn.Open mstrConnectString I have tried various connection strings - mstrConnectString="server=(local)\SQLEXPRESS;" & "integrated security=sspi;database=;"
0
8759
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8669
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9017
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6588
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3125
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2453
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2069
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.