Database design

Question

Database design

nimi74

Newbie

Points: 1
More actions
September 17, 2003 at 6:29 pm

#76054

Can someone tell me what is the best tool for database design ?

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

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

ckempste SSCoach Points: 17983 More actions · Answer 1

Well, this is an open question 🙂

I like Visio, not really a db design tool as such, more a diagrammer, but great all the same. I would also consider ERWIN, but is a tad pricey, check them out.

Write yourself up a list of "i want it to.." and "i dont care abouts.." to give yourself half a chance.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

philcart SSC-Forever Points: 47796 More actions · Answer 2

Also in the pricey range, but not as troublesome as ERWIN, is ER/Studio.

http://www.embarcadero.com/products/erstudio/index.asp

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

ckempste SSCoach Points: 17983 More actions · Answer 3

if you want to go cludgy and nasty, try system architect 🙂

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Hi Chris,

maybe I get flamed by phillcart for getting a point for another pretty useless post, but who cares anyway....

I hail thee, o mighty newborn SQL Server guru ....

Oh, ...and to close the cycle and get back to the this topic.

I like the tool that comes with SQL Server. EM's diagram designer ?!?

And I like doing this in Access and then migrating to SQL Server.

Frank

http://www.insidesql.de

Sorry, forgot to make aware that this category is NOT

'Anything.....'

Edited by - Frank Kalis on 09/18/2003 12:31:31 AM

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

philcart SSC-Forever Points: 47796 More actions · Answer 5

Ok Frank ... I'll let you off this time because you did actually respond to the topic

Damn ... now I'm just posting to up my count

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

--------------------
Colt 45 - the original point and click interface

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

quote:
Ok Frank ... I'll let you off this time because you did actually respond to the topic

never mind!

quote:
Damn ... now I'm just posting to up my count

if you continue to post that frequently like the last days, you'll very soon receive such a reply 'I hail thee...'.

If you want or not

Frank

http://www.insidesql.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

bnordberg SSCertifiable Points: 5480 More actions · Answer 7

If you need to diagram, then create the database to different systems (Oracle, Sybase, SQL Server ...) then ER Studio is probably the way to go. they have a free trial: ttp://www.embarcadero.com/downloads/download.asp

If you don't need this functionality (or can't afford it) go with Visio, Access or EM diagramer.