question

Naina avatar image
Naina asked

SQL Server Data Model Diagram

Hello,

Sorry for not being clear...i mean tools to create models of our databases.

Thanks Naina

datadata-modelling
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Do you mean a model of the system tables? Or are you looking for tools to allow you to create models of your databases?
3 Likes 3 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
If you are after some extra information on system tables - that's the current topic I'm writing about on my blog - http://www.atlantis-interactive.co.uk/blog/default.aspx - although not diagrammatic, it does have some extra information, explaining where MSDN is misleading or just plain wrong.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Sorry, I don't understand the question either. Please clarify what it is that you're looking for.
0 Likes 0 ·
Naina avatar image Naina commented ·
Hello, Sorry for not being clear...i mean tools to create models of our databases. Thanks Naina
0 Likes 0 ·
Naina avatar image Naina commented ·
Thanks a lot guyss......
0 Likes 0 ·

3 Answers

·
David 1 avatar image
David 1 answered

Sybase PowerDesigner, CA ER-Win Data Modeler, Embarcadero ER Studio, Microsoft Visio

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Bhaskar avatar image Bhaskar commented ·
Microsoft Visio is simple one and nice job. I use this for modelling and reversed engineered to get diagrams of existing database.
0 Likes 0 ·
Queue avatar image
Queue answered

I suppose you are asking about how to go about modelling your database,for a simple db, you can start with database diagrams in sql server, and if it is large then go for something like erwin from ca or Embarcadero studio or any other tool that you like.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jay Bonk avatar image
Jay Bonk answered

I've used both CA ER-Win and ModelRight.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.