N
Neil
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.
developing table schemas.
A
Allen Browne
A utility to develop table schemas?
If ou are looking for suggestions on how to design schemas for a variety of
needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm
In general, though, you only go go the trouble of creating a custom database
if there is no off-the-shelf solution. Therefore the bespoke Access
databases you create all have unique needs, and cannot be designed by a
utility.
If ou are looking for suggestions on how to design schemas for a variety of
needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm
In general, though, you only go go the trouble of creating a custom database
if there is no off-the-shelf solution. Therefore the bespoke Access
databases you create all have unique needs, and cannot be designed by a
utility.
S
susiedba
what do you want to do.. print schemas?
export schemas to word?
I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer
export schemas to word?
I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer
D
David F Cox
When I have seen questions concerning complex logic on newsgroups I have
wished for a sketchpad where I could draw a flowchart. Other times I have
longed to be able to share a relationship diagram. This looks like a
possible answer. I would like to hear more expert views on this.
wished for a sketchpad where I could draw a flowchart. Other times I have
longed to be able to share a relationship diagram. This looks like a
possible answer. I would like to hear more expert views on this.
J
Jamie Collins
I think the best way of describing a schema using text is SQL DDL!
Even if I could post an ORM diagram, would most readers be able to
interpret it?
Jamie.
--
D
David F Cox
Maybe there is yet another Access feature that I have never come across. Is
it possible to export an Access Table or relationship diagram as DDL?
it possible to export an Access Table or relationship diagram as DDL?
J
Jamie Collins
David said:
SQL DDL creates database objects, not the other way around ;-)
Jamie.
--
A
Armen Stein
Except in SQL Server, where you can script out the structure of an
existing database into DDL.
N
Neil
I meant just a tool for playing with table designs and providing a graphical
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.
T
Tim Marshall
Neil said:
Might be, but I find small yellow stickies (post it notes) work great
when conceptualizing a design. It's certainly possible I'm in the dark
ages, though.
J
Jamie Collins
Armen said:
....and the typical results demonstrate why it is rarely a good idea to
use GUI tools to 'write' SQL code for you <vbg>!
Jamie.
--
D
David F Cox
I believe Microsoft's Visio might do what you want.
K
Karl
You can do this in Excel.
Neil said:
N
Neil
Yes, I can list tables and fields in Excel; but I'd like to visually
display table relationships and joins. Surely there must be a tool out there
that does this.
display table relationships and joins. Surely there must be a tool out there
that does this.
N
Neil
With me, if it's not on my PC, it gets lost. The only way I find mail is by
knowing which part of the floor it was left on.... My computer files, on the
other hand, are very organized.
knowing which part of the floor it was left on.... My computer files, on the
other hand, are very organized.
N
Neil
Could be; but I was hoping for some free or inexpensive tool for doing
this -- doesn't have to be fancy.
You know, it's interesting: I was expecting lots of replies saying, "I use
this," or "I use that." But that hasn't been the case. So what do most
people do, just design with pencil and paper or just Word or Excel? Or just
go straight to table design?
this -- doesn't have to be fancy.
You know, it's interesting: I was expecting lots of replies saying, "I use
this," or "I use that." But that hasn't been the case. So what do most
people do, just design with pencil and paper or just Word or Excel? Or just
go straight to table design?
M
Michael Gramelspacher
I was also expecting to see lots of replies.
This is the only thing I have encountered that is free.
(Assuming it can still be downloaded.)
http://www.fabforce.net/dbdesigner4/
it is really for use with Mysql.
I have also seen this recommended, but the cheapest version is
$229. http://www.datanamic.com/
There are many others and most are expensive.
A
Armen Stein
Here's what we do:
At first: on a whiteboard or using pencil & paper, we sketch out the
high level tables using circles (tables) and lines (relationships). We
indicate the one and many side of each relationship. We may note a
few critical fields under each table, or some sample data in quotes.
When we feel that the initial table level of design will work, we
enter it directly into Access or SQL Server, and use the relationships
window (in Access) or a Diagram (in SQL Server) to lay it all out
graphically.
We don't use a third party tool, but Visio can do it (as another
poster suggested). Another (more expensive) tool is ERWin.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
At first: on a whiteboard or using pencil & paper, we sketch out the
high level tables using circles (tables) and lines (relationships). We
indicate the one and many side of each relationship. We may note a
few critical fields under each table, or some sample data in quotes.
When we feel that the initial table level of design will work, we
enter it directly into Access or SQL Server, and use the relationships
window (in Access) or a Diagram (in SQL Server) to lay it all out
graphically.
We don't use a third party tool, but Visio can do it (as another
poster suggested). Another (more expensive) tool is ERWin.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com
D
David F Cox
What actually I use is a large sheet of paper and a very soft pencil 4B - 6B
and a good eraser. Usually the diagram never gets finished. When I have
sorted out the difficult bits I am off into the table design window. I am
not advocating that anybody follow my example.
and a good eraser. Usually the diagram never gets finished. When I have
sorted out the difficult bits I am off into the table design window. I am
not advocating that anybody follow my example.
N
Neil
Thanks for that!
Michael Gramelspacher said: