Best open source tool for database design / ERDs?
postgresql_autodoc and dia.
Show quoted text
On 28 May 2006 05:19:04 -0700, dananrg@yahoo.com <dananrg@yahoo.com> wrote:
What open source tool do people here like for creating ER diagrams?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
I use the azzuri eclipse plugin. It's rudimentary, but get's the job
done for smaller (a couple of dozens of tables) models. It has a
commercial version which might be even better.
t.n.a.
Show quoted text
On 28 May 2006 05:19:04 -0700, dananrg@yahoo.com <dananrg@yahoo.com> wrote:
What open source tool do people here like for creating ER diagrams?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
Druid works ok....
http://druid.sourceforge.net/index.html
BTJ
On 28 May 2006 05:19:04 -0700
dananrg@yahoo.com wrote:
Show quoted text
What open source tool do people here like for creating ER diagrams?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
On 5/29/06, Bjørn T Johansen <btj@havleik.no> wrote:
Druid works ok....
Are there a couple of screenshots available on the net, a flash demo perhaps?
t.n.a.
On Mon, 29 May 2006 14:43:19 +0200
"Tomi NA" <hefest@gmail.com> wrote:
On 5/29/06, Bjørn T Johansen <btj@havleik.no> wrote:
Druid works ok....
Are there a couple of screenshots available on the net, a flash demo perhaps?
t.n.a.
Don't know...
BTJ
dananrg@yahoo.com wrote on 29.05.2006 13:06:
Thanks. What about DIA - http://www.gnome.org/projects/dia/
...or DB Designer - http://fabforce.net/dbdesigner4/ (this one claims
to be feature-equivalent, or in the sphere of, products like Oracle's
Designer, ERWin, and Rational Rose.
This is not maintained any longer (unfortunately because I really like it). And
the support for non-MySQL databases is nearly non-existing.
As the actual model is saved in XML I wrote an XSLT task to convert the
DbDesigner to an Oracle SQL script (CREATE TABLE....). It shouldn't be that hard
to adjust it for Postgres. If anyone is interested I can post it (the Oracle
version) here.
Regards
Thomas
Thanks Thomas. That's too bad about DB Designer. I didn't realize it
had been abandoned.
What do y'all think of DIA?
Anyone know if DIA will generate CREATE TABLE statements from an ER
diagram?
I'd like to have a program where I can create my db design, then be
able to instantiate the design in PostgreSQL as well as MySQL.
I'll pay for a good commercial tool if it costs less than USD $100.
Thanks.
You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB platforms
and is FREE!!!
Sean
On 6/1/06 5:44 AM, "dananrg@yahoo.com" <dananrg@yahoo.com> wrote:
Show quoted text
Anyone know if DIA will generate CREATE TABLE statements from an ER
diagram?I'd like to have a program where I can create my db design, then be
able to instantiate the design in PostgreSQL as well as MySQL.I'll pay for a good commercial tool if it costs less than USD $100.
Thanks.
On Thu, 1 Jun 2006, Sean Davis wrote:
You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB platforms
and is FREE!!!
Allow me to second that suggestion. I used one (whose name I don't recall)
from Azzurri in Japan. It was an easy installation into eclipse, allowed me
to design the schema and relations, then generated the postgres statements. I
used it on one project; haven't had the need since then (and that was 2.5
years ago).
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
Hi,
tedia2sql will do the job: http://tedia2sql.tigris.org
Greetings,
Leif
On Thu, 1 Jun 2006 dananrg@yahoo.com wrote:
Show quoted text
Anyone know if DIA will generate CREATE TABLE statements from an ER
diagram?I'd like to have a program where I can create my db design, then be
able to instantiate the design in PostgreSQL as well as MySQL.I'll pay for a good commercial tool if it costs less than USD $100.
Thanks.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Dia itself is just a diagramming tool. However, there are a number of
apps at http://www.gnome.org/projects/dia/links.html that will take Dia
diagram files and generate db schemas for you...
dananrg@yahoo.com wrote:
Show quoted text
Anyone know if DIA will generate CREATE TABLE statements from an ER
diagram?I'd like to have a program where I can create my db design, then be
able to instantiate the design in PostgreSQL as well as MySQL.I'll pay for a good commercial tool if it costs less than USD $100.
Thanks.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
On 6/1/06 12:29 PM, "Tomi NA" <hefest@gmail.com> wrote:
On 6/1/06, Sean Davis <sdavis2@mail.nih.gov> wrote:
You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB platforms
and is FREE!!!What's it called?
Import Notes
Reply to msg id not found: d487eb8e0606010929k4b8b265n325a38724603122b@mail.gmail.com | Resolved by subject fallback
Anyone here used both DIA and schema export extensions for it as well
as the Eclipse ERD plug-in for creating and exporting schemas - I mean
outputting DDL statements in PostgreSQL? Or Druid?
Which do you like best and why?
Thanks.
On Thursday 01 June 2006 15:39, Sean Davis wrote:
You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB
platforms and is FREE!!!
Would you mind give me the plugin name (or url) ?
TIA,
D.
On Fri, 2 Jun 2006, Dany De Bontridder wrote:
On Thursday 01 June 2006 15:39, Sean Davis wrote:
Would you mind give me the plugin name (or url) ?
Dany,
It was mentioned yesterday; the name is 'clay' and if you aim your browser
at <http://www.azzurri.jp/en/software/clay/> you can read all about it.
I found it easy to learn and use and quite effective. Of course, since then
I've stopped using eclipse. I'm back to emacs.
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
Rich Shepard wrote:
On Fri, 2 Jun 2006, Dany De Bontridder wrote:
On Thursday 01 June 2006 15:39, Sean Davis wrote:
Would you mind give me the plugin name (or url) ?
Dany,
It was mentioned yesterday; the name is 'clay' and if you aim your
browser
at <http://www.azzurri.jp/en/software/clay/> you can read all about it.I found it easy to learn and use and quite effective. Of course,
since then
I've stopped using eclipse. I'm back to emacs.Rich
a caveat: I don't believe, from my reading of the license, that this is
an open source software product.
