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 characters needed characters left characters exceeded

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

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 ·
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 ·
Sorry, I don't understand the question either. Please clarify what it is that you're looking for.
0 Likes 0 ·
Hello, Sorry for not being clear...i mean tools to create models of our databases. Thanks Naina
0 Likes 0 ·
Thanks a lot guyss......
0 Likes 0 ·
David 1 avatar image
David 1 answered

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

1 comment
10 |1200 characters needed characters left characters exceeded

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

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 characters needed characters left characters exceeded

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 characters needed characters left characters exceeded

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.