E R Diagram

Question

Post reply

E R Diagram

chetana samal

Old Hand

Points: 388
More actions
July 1, 2005 at 9:01 am

#68149

How to convert an ER diagram for an existing database created in sql server into some other format such as JPEG or something for easier viewing of the client/user. This is relatively big database around some 300 plus tables

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

I don't know of any way to do it.

You'll need to purchase a software package.

Er Win,

http://www3.ca.com/Solutions/Product.asp?ID=260

ErStudio by embarcadero

http://www.embarcadero.com/products/products.html

Visio Enterprise Edition (Not good with over 100 tables)

chetana samal Old Hand Points: 388 More actions · Answer 2

Thanks Ray

yeah, I know about ER Win. But it is little pricey. But any idea about De Zign for Databases software from http://www.datanamic.com/order/index.html

The reviews seems good

noeld SSC Guru Points: 96590 More actions · Answer 3

How about Printing that to a PDF Writer (printer) ?

Just my $0.02

* Noel

Ray M SSC-Insane Points: 21093 More actions · Answer 4

from where noeld?

Diagrams in Enterprise Mangler?

That is a very difficult tool to use.

And a PDF Writer like Adobe Acrobat is a little pricier than Erwin, or ER Studio.

2c is your change .

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 5

Did you try Visio? It's not bad if you already own it. If you have 300 tables, you might consider subject areas. 300 tables on a big .jpg is going to be a bit worthless.

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.

noeld SSC Guru Points: 96590 More actions · Answer 6

yes diagrams in Enterprise Manager (not Mangler)

PDF writer : Price: $19.95

Erwin: Price: $3,995.00

ER Studio: could be Price: £3,225.38

who was your math teacher?

* Noel

chetana samal Old Hand Points: 388 More actions · Answer 7

Thanks a lot to all of you for suggestions. I am using ER Studio now to get the job done. But the problem still persists...How to get the entire database ERD exported to a file and save it so that anyone without having ER Studio can view it and take a print out. The entire ERD will be some 50 pages..

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 8

ERWin and Embarcadero both have the ability to export to a website. They could view it there and print off each page.

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.

chetana samal Old Hand Points: 388 More actions · Answer 9

That sounds interesting! But I don't see anywhere 'export to...websites'. How do I export in Embarcadero

mxhxr SSChasing Mays Points: 611 More actions · Answer 10

You could do a "Print to file", from ERStudio, ERwin, or wherever. Name the file fileName.eps, then run it through Acrobat to create a PDF. As stated, I can't see the use of such a large, cumbersome model in one document... I suggest you split it into functional subject areas.

Karen Lopez SSC Enthusiast Points: 199 More actions · Answer 11

In ER/Studio 6.6, you can FILE/EXPORT IMAGE or, even better, just SELECT ALL, then copy and paste the diagram into MS Word or any other application capable of accepting graphics.

In ERwin, just run the Report feature to generate HTML. Ensure you have selected Diagram to be included, then ERwin will generate a series of webpages including the diagram.

For those with a bit more money to spend, both ERwin and ER/Studio have read-only versions of their products. These list for about $800 or more.