x
login about faq Site discussion (meta-askssc)

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 '10 at 05:42 AM in Default

Naina gravatar image

Naina
63 12 12 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 '10 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 '10 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 '10 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 '10 at 08:51 AM Naina

Thanks a lot guyss......

Apr 29 '10 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 '10 at 09:58 AM

Queue gravatar image

Queue
239 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 '10 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 '10 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 '10 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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x41
x10

asked: Apr 28 '10 at 05:42 AM

Seen: 1593 times

Last Updated: Apr 28 '10 at 08:51 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.