Need to create a "fancy" Database Diagram

Question

Post reply

Need to create a "fancy" Database Diagram

Mark Markov

Mr or Mrs. 500

Points: 592
More actions
January 2, 2006 at 6:57 pm

#92891

What is the best product that allows us to create a fancy database diagram (one that can be printed on a plotter and hung on the wall for everyone to see). Looking for something more than "Diagrams" in SQL Server, such as relationships, ability to make separate data marts, etc. Thank you.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736150 More actions · Answer 1

Don't know any free ones. If you have Office Pro, Visio will work.

Paint I guess

Jason Hall Hall of Fame Points: 3906 More actions · Answer 2

Take a look at Qdesigner from Quest.

http://www.quest.com/qdesigner

Dale Corey SSCrazy Eights Points: 9019 More actions · Answer 3

I use SmartDraw for all network, flow chart, UML, etc. diagrams:

http://www.smartdraw.com/exp/ste/home/

It's cheaper than Visio and you can download a free trial. In a pinch, I've even used the Drawing tools in MS Word.

All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio

juliekenny SSCommitted Points: 1558 More actions · Answer 4

We have found Case Studio 2 to be good and not very expensive. You can create drawings by importing the SQL and vice-versa, so it gives you that bit more than drawing. There is a downloadable demo copy available.

http://www.casestudio.com/

Some things we do use SmartDraw for though, it depends exactly what you want.

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 5

ERWIN data modeler is the "best" product. It's expensive and may be overkill for what you're trying to accomplish.

Rick Lowrey Right there with Babe Points: 785 More actions · Answer 6

ER/Studio from Embarcadero is another good product comparable to (better than, IMHO) ERwin. Again, kinda pricey and probably overkill as well.