Entity Relationship diagram editor
-
MS used to sell SQL Server 2000 Dev Editon for like $50 that did everything you need. Also, you can use Access via ODBC to connect to most backends, to use it's designer (it edits the DB directly, for the SQL you'd have to use the DBMS for a dump). Or did I miss the idea?
Jeremy Falcon
Jeremy Falcon wrote:
Or did I miss the idea?
It's "halfway" there. I have a developer's edition of SQL which I snatched from work. However, its diagram editor understands the physical model only (which is a bit too low level for my taste). I like the ER-notation (1:1, 1:n, n:m, identifying, non-identifying, etc), because it matches my thoughts better than "FK->PK". :)
-- A Stern Warning of Things to Come
-
Jeremy Falcon wrote:
Or did I miss the idea?
It's "halfway" there. I have a developer's edition of SQL which I snatched from work. However, its diagram editor understands the physical model only (which is a bit too low level for my taste). I like the ER-notation (1:1, 1:n, n:m, identifying, non-identifying, etc), because it matches my thoughts better than "FK->PK". :)
-- A Stern Warning of Things to Come
Jörgen Sigvardsson wrote:
I like the ER-notation (1:1, 1:n, n:m, identifying, non-identifying, etc), because it matches my thoughts better than "FK->K".
Um, beats me then. I guess I'm old fashioned. :-D
Jeremy Falcon
-
I'm trying to find a free one, which doesn't expire in 30 days, and costs little or nothing. I'm doing some database stuff on my free time, so I can't buy it through work. Dezign for Databases is nice, but I really don't feel like paying for it since it's for personal use. Do you know of a free one, which is fairly good? (It's ok if it's low cost < $50) Reverse engineering from an existing database would be nice, but not a requirement. Generation of SQL code is however. Thanks. :)
-- Federal law prohibits changing the channel
Jörgen Sigvardsson wrote:
Entity Relationship
Does it have to be an Entity Relationship editor? I have been using Sparx EA UML modeling for much of my work and following some learning curve have been successful generating DDL for oracle 9i. I would think many of the UML modelers would have similar capability.
-
Jörgen Sigvardsson wrote:
Entity Relationship
Does it have to be an Entity Relationship editor? I have been using Sparx EA UML modeling for much of my work and following some learning curve have been successful generating DDL for oracle 9i. I would think many of the UML modelers would have similar capability.
Michael A. Barnhart wrote:
Does it have to be an Entity Relationship editor?
Yes. In my experience, all modeling tools which aren't specifically designed for a particular task, isn't very good. I did dabble a little with the trial, but I didn't like it. I'll save the UML stuff for the code. :)
-- In Hypno-Vision
-
I'm trying to find a free one, which doesn't expire in 30 days, and costs little or nothing. I'm doing some database stuff on my free time, so I can't buy it through work. Dezign for Databases is nice, but I really don't feel like paying for it since it's for personal use. Do you know of a free one, which is fairly good? (It's ok if it's low cost < $50) Reverse engineering from an existing database would be nice, but not a requirement. Generation of SQL code is however. Thanks. :)
-- Federal law prohibits changing the channel
-
I'm trying to find a free one, which doesn't expire in 30 days, and costs little or nothing. I'm doing some database stuff on my free time, so I can't buy it through work. Dezign for Databases is nice, but I really don't feel like paying for it since it's for personal use. Do you know of a free one, which is fairly good? (It's ok if it's low cost < $50) Reverse engineering from an existing database would be nice, but not a requirement. Generation of SQL code is however. Thanks. :)
-- Federal law prohibits changing the channel
you can try dbdesigner[^].
-
I'm trying to find a free one, which doesn't expire in 30 days, and costs little or nothing. I'm doing some database stuff on my free time, so I can't buy it through work. Dezign for Databases is nice, but I really don't feel like paying for it since it's for personal use. Do you know of a free one, which is fairly good? (It's ok if it's low cost < $50) Reverse engineering from an existing database would be nice, but not a requirement. Generation of SQL code is however. Thanks. :)
-- Federal law prohibits changing the channel
Although it's $300, I've had a number of people tell me about how great a deal the new Microsoft Action Pack[^] is, which includes Visio. You might find it worth checking into.
Author of The Career Programmer and Unite the Tribes www.PracticalStrategyConsulting.com
-
you can try dbdesigner[^].
I tried it, but it's far too MySQLish.. :(
-- Behold, for I am THE CORRUPTOR!
-
Hmm.. definately worth checking out. Thanks!
-- Behold, for I am THE CORRUPTOR!
-
Although it's $300, I've had a number of people tell me about how great a deal the new Microsoft Action Pack[^] is, which includes Visio. You might find it worth checking into.
Author of The Career Programmer and Unite the Tribes www.PracticalStrategyConsulting.com
Visio is only good for small stuff in my opinion. It also doesn't visually show the type of relations between entities. I want need the visual cues. :)
-- Behold, for I am THE CORRUPTOR!