x

SQL Server Data Model Diagram

Hello,

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

Thanks Naina

more ▼

asked Apr 28, 2010 at 05:42 AM in Default

Naina gravatar image

Naina
63 13 13 14

Do you mean a model of the system tables? Or are you looking for tools to allow you to create models of your databases?
Apr 28, 2010 at 05:47 AM Kev Riley ♦♦
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.
Apr 28, 2010 at 06:03 AM Matt Whitfield ♦♦
Sorry, I don't understand the question either. Please clarify what it is that you're looking for.
Apr 28, 2010 at 08:17 AM Grant Fritchey ♦♦

Hello,

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

Thanks Naina
Apr 28, 2010 at 08:51 AM Naina
Thanks a lot guyss......
Apr 29, 2010 at 08:38 AM Naina
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Apr 28, 2010 at 09:58 AM

Queue gravatar image

Queue
250 2 2 3

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Apr 28, 2010 at 09:47 AM

David 1 gravatar image

David 1
1.8k 1 3

Microsoft Visio is simple one and nice job. I use this for modelling and reversed engineered to get diagrams of existing database.
May 12, 2010 at 01:50 PM Bhaskar
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Apr 28, 2010 at 12:58 PM

Jay Bonk gravatar image

Jay Bonk
1.4k 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x46
x11

asked: Apr 28, 2010 at 05:42 AM

Seen: 2258 times

Last Updated: Apr 28, 2010 at 08:51 AM