How to get ER Diagram for DB in SQL2005

Question

How to get ER Diagram for DB in SQL2005

go2vish

Old Hand

Points: 333
More actions
January 7, 2009 at 11:36 pm

#203755

Hi,
Can someone please help!!:crying:
I need to get the ER Diagram for a certain Database in SQL Server 2005.
Please reply
Thanks!!
Vishwajeet

Viewing 3 posts - 1 through 2 (of 2 total)

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

Eric SSCommitted Points: 1803 More actions · Answer 1

SQL 2005 has database diagramming functionality, check books online for “database diagramming”. It’s not as full featured as what you would see in Erwin or ER/Studio but it’s free.

Visio can also reverse engineer databases but I think you need the Professional version to do that.

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 2

Hi

You dont have to use ERWin Model to get the relationshhip diagram. Simple you can Database Diagramming in SQL Server. This is very good..

Check out thebelow link for more infromation.

http://www.codeproject.com/KB/database/ScriptDiagram2005.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

http://oravj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers