rudy responded:
personally, i use a pencil, because it has an eraser ;o)
Tim adds:
Yep, pencil's the best. Lots of paper. Have a trash can handy - or a
recycle bin, depending on your inclinations. :-)
FWIW, I actually use a pen and scribble out old ideas...you'd be
surprised how often I come
Oh don't get me wrong - I write my CREATE TABLE statements myself as well..
its just nice to have the reference :o)
I can also print it out and hang it on my wall - so I can see everything pretty and
stuff.
I would be scared to use MS SQL...
Who knows what you might find in it..
(
> I can then wander off and build my table creating script
> from the visual data I get from Access.
do me a favour? please test out the "upsizing wizard" from microsoft
i'm too lazy, and besides, i can write DDL, i.e. the CREATE TABLE
statements, by hand
apparently, somewhere in there, the wiz
Just been playing with access -
Don't want to use it as my database (as if) but I am actually finding it a useful tool
to throw around a few table ideas, visualise the relationships, and edit as per
neccessary.
I can then wander off and build my table creating script from the visual data I get
> http://r937.com/20020514.cfm
thanks, mark, for the link -- i owe you, bud
> > Good ol' Access?
> Huh, what is this?
access has some pretty handy wizards for table creation
it also has a "relationships" tool that lets you drag and drop columns to
define the relationships between tables, altho
Content-type: Multipart/Alternative; boundary="Alt-Boundary-28421.4303867"
--Alt-Boundary-28421.4303867
On February 18, 2003 at 1:16, Mark M wrote:
> Just curious as to what you use to design your databases?
> Tools? Pen and Paper?
Same as a web site, paper and pencil. Rudy has an awesome tool:
h
> Pen and Paper? Good ol' Access?
both of those options are good
personally, i use a pencil, because it has an eraser
;o)
visio is a middle-of-the-price-range tool i've heard good things about
erwin is comprehensive (i've used it) but costs in the thousands
there are many reasonably-priced o