How to create the ER Diagram for SQL Server Database objects

sangu_rao

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

Subscribe Reply

51979

Erland Sommarskog

(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

fireball

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

Similar topics

2433

Can't create SQL Server database with Server Explorer?

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...

.NET Framework

13996

How To PROTECT SQL Server Database Files ?

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

Microsoft SQL Server

1799

Please help: Creating a table in a sql server database

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:

ASP.NET

1529

Is there a better tool for automated creation of database objects?

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...

Visual Basic .NET

10676

Want to be able to create or view database diagrams

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...

Microsoft SQL Server

3186

Storing SQL Server 2005 objects and queries in Perforce

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...

Microsoft SQL Server

3005

File Server Database Apps and SQL Server?

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...

Microsoft Access / VBA

2229

Create client/server database application using VB6

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

Visual Basic 4 / 5 / 6

9207

How to create sql server database file from VB6 application

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=;"

Visual Basic 4 / 5 / 6

8471

What is ONU?

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...

General

8817

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8663

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7423

AI Job Threat for Devs

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...

Career Advice

6218

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5687

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4396

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2046

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1799

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General