Groups | Blog | Home
all groups > sql server (alternate) > october 2006 >

sql server (alternate) : How can I create a cool data model table map?


David Portas
10/14/2006 12:19:38 PM
[quoted text, click to view]

Take a look at Visio:

http://office.microsoft.com/en-gb/visio

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
serge
10/14/2006 12:53:20 PM
I first got this map from SQL Server Magazine subscription. Now i

see it's available to download as a PDF from Microsoft.

http://www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en

I've just installed Visual Studio Team Edition for Database Professionals

and for the next coming weeks i'll get a chance to see what kind of data

model design capabilities the product offers.



My question would be do you know how I can make our database

model look cool like this map? Would you know if this is a third party

software that does this with nice colors and all?

Do you think I can do similar quality data model map using VSTE for

DB Pro?



Thank you





christopher.secord NO[at]SPAM gmail.com
10/17/2006 12:49:17 PM
[quoted text, click to view]

Take a look at Visual Paradigm.
http://www.visual-paradigm.com/product/vpuml/

I agree that it's very useful to have nice ER diagrams handy when
coding. There is some overhead involved though as you have to format
the diagrams yourself no matter what tool you use, but it's worth it.

How does anyone code without an ER diagram??

chris
Ed Murphy
10/18/2006 2:07:34 AM
[quoted text, click to view]

Personally, I tend to work with small enough subsets that I can keep
the relationships straight in my head, but then I don't do a lot of
large-scale system-building. Alas, for many others, I expect the
AddThis Social Bookmark Button