SQL Server 2008 DB diagram

Question

SQL Server 2008 DB diagram

HBK_4700

SSCrazy Eights

Points: 8932
More actions
June 17, 2011 at 12:56 pm

#389767

Hi,
As part of documentation, I have created a database diagram using MS Visio (db has 250+ tables). And converted to pdf format.
But the tables and relations are not that much clear to present to some non-technical guys.
So I want to know if there any other option for making the diagram more clear. (ex : JPEG image)
And also wondering can I take the hardcopy of diagram?
Thank you..

Viewing 5 posts - 1 through 4 (of 4 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

laddu4700 (6/17/2011)
So I want to know if there any other option for making the diagram more clear. (ex : JPEG image)
And also wondering can I take the hardcopy of diagram?

Exporting Visio Diagrams in Other File Formats

http://www.linuxhomenetworking.com/forums/showthread.php/16255-Exporting-Visio-Diagrams-in-Other-File-Formats

And also wondering can I take the hardcopy of diagram?

Not sure what you are asking? Do you mean print the ERD from Visio?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 2

And also wondering can I take the hardcopy of diagram?

Not sure what you are asking? Do you mean print the ERD from Visio?

[/quote]

Yes, I meant taking print -hard copy of db diagram

also any idea of third party tools to create a db diagram

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

laddu4700 (6/20/2011)

Yes, I meant taking print -hard copy of db diagram
also any idea of third party tools to create a db diagram

Can't you print yor ERD in Visio?

If you have the cash you can purchase Erwin. 😎

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

ELLISW SSC Veteran Points: 234 More actions · Answer 4

Try TOAD for Data Analysts. There is a new beta trial 3. If you try to get 2.7 free if you are lucky.