by Christian Cantrell

 Comments (13)

Created

March 25, 2004

What are Macromedia developers out there using for ER diagraming? For small projects (meaning a few tables), I just use text files and write the SQL by hand. For larger projects, I have actually used UML tools with some success, and more generic tools like OmniGraffle. Last night, I decided I wanted something more sophisticated, however, that could generate SQL for me, so I downloaded a tool called XERD for OS X. So far, I’m pretty impressed with it, though I haven’t generated any SQL with it yet, which I believe will be the true test. I like the fact that it’s simple and streamlined, serving just this one specific purpose, and that it supports multiple databases (MySQL, Oracle, PostgreSQL, Sybase, and OpenBase).

What other tools are people using, for Windows, OS X, Linux and Solaris?

COMMENTS

  • By Jaime V. Jacinto Jr. - 11:34 PM on March 25, 2004   Reply

    Christian Cantrell in his article “Macromedia Flash Remoting Makes Macromedia Flash an Alternative to JSP and Applets” mentioned about Flash Remoting will invoke JSPs.I would like to know how is it done and please, provide me technical example of this.Your help is highly appreciated. Thanks a lot.

  • By dave ross - 11:42 PM on March 25, 2004   Reply

    I use Visio 2000… 2002 sucks because it won’t forward engineer/script out a db, they purposely removed that functionality to sell more copies of VS.NET Enterprise Architect (& I already own VS.NET Pro). Since I work with nearly 100% MS-SQL db’s, Visio seemed like a logical choice. 2002 can reverse engineer existing db’s pretty good though.

  • By Zac Spitzer - 12:37 AM on March 26, 2004   Reply

    I have used ER/Studio http://www.embarcadero.com/products/erstudio/ on a lot of projects,it’s quite pricy, there’s no list price but i have haggled with them in the past and then paid a lot less than they asked for to start with :) but it’s a real tool for doing E/R stuff… makes visio look like a flowcharting tool… err it is :-) windows platform only, but supports all the major databases out therebut a very good product over all

  • By Barry Frost - 5:20 AM on March 26, 2004   Reply

    I’ve been happily using CASE Studio for the last year. It works with most databases out there and generates all the DDL for you. I’ve found its HTML/RTF reporting to be very useful for a project website. It’s reasonably-priced too.Windows-only I believe.http://www.casestudio.com/enu/products.aspx

  • By Thomas - 6:46 AM on March 26, 2004   Reply

    CaseStudio absolutely:http://www.casestudio.comIs the best ERD Software with the lowest price.

  • By Andy Tyrone - 10:34 AM on March 26, 2004   Reply

    I’ve used a few, from Visio to ERWin, but I’ve settled on a more affordable program that is powerful enough for our needs here. It’s called Dezign for Databases. The author has done a great job on the new 3.x version, which is very affordable in my opinion.http://www.datanamic.com/

  • By Cortlandt Winters - 11:21 AM on March 26, 2004   Reply

    I also use and like Dezign for Databases.

  • By David - 1:39 PM on March 26, 2004   Reply

    Dezign x3

  • By Todd - 9:35 AM on March 27, 2004   Reply

    Add one more for Case Studio… I’ve used datanamic.com’s stuff before and I’ve found Case Studio to be a little better.

  • By Sean Corfield - 1:06 PM on March 28, 2004   Reply

    Together Control Center (now owned by Borland). It’s a UML CASE tool with round-trip (forward/reverse) engineering for Java and other languages and it also has full-function ERD functionality.

  • By Tedd - 11:47 PM on April 13, 2004   Reply

    Sparx Systems Enterprise Architect 3.51

  • By Tedd - 11:48 PM on April 13, 2004   Reply

    Sparx Systems Enterprise Architect 3.51

  • By Luis - 2:30 PM on June 2, 2004   Reply

    Together Control Center 5.5. It works on Windows, Linux and now working fine in Mac OS X 10.3.4/JDK 1.4.2. Never used newer Together Borland’s versions, though.

ADD A COMMENT