ÿþ<html><head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=1WaXNDFE" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://www.databaseanswers.org/modelling_tools.htm","20220207025337","https://web.archive.org/","web","/_static/", "1644202417"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=qtvMKcIJ" /> <!-- End Wayback Rewrite JS Include --> <title>Data Modelling Tools</title> <link rel="stylesheet" href="/web/20220207025337cs_/http://www.databaseanswers.org/styles/style.css"> </head> <body bgcolouur="#98CEFD" text="#202020"> <table width="100%"> <tr> <td align="left" valign="middle"> <img alt="Database Answers Logo" height="58" width="400" src="/web/20220207025337im_/http://www.databaseanswers.org/images/dba_400_home.jpg"> </td> <td align="right" height="95" rowspan="2" valign="top"> <a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/Lady_Gabriella_Windsor" target="_NEW"> <img align="right" alt="Lady Gabriella Windsor, a Model (Click for Wikipedia entry)" border="1" width="122" height="90" src="/web/20220207025337im_/http://www.databaseanswers.org/images/gabriella_sml.jpg"></a> </td> </tr> </table> <!--- START OF APRIL 1ST. MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20220207025337im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="5%" wiiiidth="6%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%" wiiiidth="10%"><a style="text-decoration:none" href="about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <td align="LEFT" width="8%" wiiiidth="18%"><a style="text-decoration:none" href="contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF APRIL 1ST. MENU BAR ---> <!--- START OF PAGE NAME ---> <font color="blue" face="Verdana" size="2"> <table bgcolor="#98CEFD" border="0" cellpadding="5" cellspacing="5" width="100%"> <tr> <td height="32" background="/web/20220207025337im_/http://www.databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20220207025337im_/http://www.databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20220207025337im_/http://www.databaseanswers.org/images/nav_bg.jpg" height="32" width="10%"><pre><font color="yellow" colouuur="#FFFFFF" face="Verdana" size="2">Data Modelling Tools&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <table bgcolor="#98CEFD" width="100%"> <tr><td><font color="blue" face="Verdana" size="2"> <!-- begin body Text --> Here's a short list of our <a href="favourite_data_modelling_tools.htm">Favourite Data Modelling Tools</a> and here is <a href="https://web.archive.org/web/20220207025337/http://www.linkedin.com/groupItem?view=&amp;srchtype=discussedNews&amp;gid=988447&amp;item=29745443&amp;type=member&amp;trk=eml-anet_dig-b_pd-ttl-cn" target="_NEW">an excellent discussion about Modelling Tools</a> on <b>LinkedIn</b>, which makes <a href="https://web.archive.org/web/20220207025337/http://www.sybase.co.uk/products/modelingdevelopment/powerdesigner" target="_NEW">PowerDesigner</a> the most popular product. <br><br><b>Wikipedia</b> has published a <a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/Data_modeling_tools" target="_NEW">Comparison of Data Modelling Tools</a> which is worth a look - and thanks to <b>Erick Calder</b> for telling us about it. <p> There's a <a href="#SHORT_NOTE"><b>short note</b></a> about about Data Modeling and Database design at the bottom of the page. <br><br>if you have any specific recommendations or comments, please <a href="https://web.archive.org/web/20220207025337/mailto:dba_requests@barryw.org?subject=Comments on Modelling Tools"><b>Email me</b></a> <hr> On April 27th. 2014, I came across an interesting discussion on LinkedIn about <a href="https://web.archive.org/web/20220207025337/http://www.linkedin.com/groupItem?view=&amp;gid=1779772&amp;item=5853885579736920065&amp;type=member&amp;commentID=-1&amp;trk=eml-b2_anet_digest-null-5-null&amp;fromEmail=fromEmail&amp;ut=3UCFSHs2QmHCc1#commentID_-1" target="_NEW"> the future of ERwin</a> (after the takeover by <b>Embarcadero</b>). <br><b>ERwin</b> has announced an integration with <b>Casewise</b> for enterprise architecture and business process modeling. <br><b>PowerDesigner</b> has a more complete vision than either. <!--- and there was <A HREeeeF="http://www.cs.queensu.ca/FAQs/SE/vendor.html" TARGET=_NEW> an even more comprehensive list of CASE Tool Vendors</A>, maintained by David Alex Lamb of Queen's University, Ontario, Canada, but the link doesn't work right now. ---> <br><br> <center><table border="1" cellpadding="5"> <tr> <td bgcolor="white" colspan="4"><center><font color="blue" face="Verdana" size="2"><b><font color="red">Cloud-based Modelling Tools</font></b> <br>Please email me on info@barryw.org if you know of any other Cloud-based Tools - thanks a lot !!! </td> </tr> <tr> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>REVIEW</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>REVIEWER</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>&nbsp;</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>COMMENTS</b></td> </tr> <tr> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/https://www.simple-talk.com/sql/database-administration/five-online-database-modelling-services/" target_new>Review of 5 Tools</a> </td> <td bgcolor="white" valign="top"><a href="https://web.archive.org/web/20220207025337/https://www.simple-talk.com/author/robert-sheldon/" target="_NEW"><font color="blue" face="Verdana" size="2">Robert Sheldon</a></td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">N/A</td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">Excellent coverage of 5 Online Tools (including Vertabelo)</td> </td> </tr> <tr><td colspan="4">&nbsp;&nbsp;&nbsp;</td></tr> <tr> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>PRODUCT</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>VENDOR</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>PRICE</b></td> <td bgcolor="white"><center><font color="blue" face="Verdana" size="2"><b>COMMENTS</b></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://sqldbm.com/" target="_NEW">SQLDbm</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sqldbm.com/Project/Dashboard/" target="_NEW">SQLDbm</a></td> <td valign="top"><font color="red" face="Verdana" size="2"><b>Free</b></font></td> <td valign="top"><font color="blue" face="Verdana" size="2"> <b>Sample Data Model</b> <br> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/sql_dbm_diagram.jpg"> <br><br><br> <!--- <IMG SRC="images/sql_dbm_diagram aug20th.jpg"> -------> </td> </tr> <tr> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://turanto.com/index.php/whats-turanto" target_new>Turanto</a></td> <td bgcolor="white" valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.turanto.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Turanto</a></td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">"Please call for prices"</td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">Comes with a <a href="https://web.archive.org/web/20220207025337/http://turanto.com/index.php/portfolio" target="_NEW"> Portfolio of 8 Applications.</a> </td> </tr> <tr> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.vertabelo.com/" target_new>Vertabelo</a></td> <td bgcolor="white" valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.vertabelo.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Vertabelo</a></td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">$9, $29 or $99/month</td> <td bgcolor="white" valign="top"><font color="blue" face="Verdana" size="2">Powerful product with very flexible features. </td> </tr> <tr><td bgcolor="white" colspan="4"><center><font color="blue" face="Verdana" size="2"><b><font color="red">'In-Premise' Modelling Tools</font></b> </tr> <tr> <td bgcolor="blue"><center><font color="white" face="Verdana" size="2"><b>PRODUCT</b></td> <td bgcolor="blue"><center><font color="white" face="Verdana" size="2"><b>VENDOR</b></td> <td bgcolor="blue"><center><font color="white" face="Verdana" size="2"><b>PRICE</b></td> <td bgcolor="blue"><center><font color="white" face="Verdana" size="2"><b>COMMENTS</b></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.aquafold.com/er-modeler.html" target="_NEW"> AquaData Studio ER Modeler</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.aquafold.com/" target="_NEW"><font color="blue" face="Verdana" size="2">AquaFold</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$400</td> <td valign="top"><font color="blue" face="Verdana" size="2">A <font color="red">Free</font> 14-day evaluation copy can be downloaded. <br>The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price. <br>"Discounted licences are available for qualified Academic users and <font color="red">Free</font> licenses are available for qualified Open Source Software (OSS) Developers." </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.altova.com/databasespy.html" target="_NEW">Altova Database Spy</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.altova.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Altova</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$499 or $999</td> <td valign="top"><font color="blue" face="Verdana" size="2">One of a broad range of Tools. Thanks to <b>Graham Lattin</b> for telling me about the change in the link. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.archimate.org/" target="_NEW">Archimate</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.opengroup.org/subjectareas/enterprise/archimate" target="_NEW"><font color="blue" face="Verdana" size="2">Open Group</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> Trial available</td> <td valign="top"><font color="blue" face="Verdana" size="2">Archmimate is described as an Enterprise Architecture Modelling Tool, <b>which would be great ;-)</b>. Unfortunately, the download is for documentation and not for the product !!! It looks like Archimate is a specification for which a number of Vendors have developed Modelling Tools. Here's <a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/ArchiMate" target="_NEW"><b>Wikipedia's entry for Archimate</b></a>. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.argouml.org/" target="_NEW">Argo UML</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.tigris.org/" target="_NEW"><font color="blue" face="Verdana" size="2">Tigris</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red"><b>Free</b></font> - Open Source</td> <td valign="top"><font color="blue" face="Verdana" size="2">For Modelling UML Diagrams - but not for the faint-hearted. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://astah.net/features/er-diagram" target="_NEW">Astah ER Diagrams</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.change-vision.com/index_en.html" target="_NEW"><font color="blue" face="Verdana" size="2">Change Vision</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://astah.change-vision.com/en/shopping/steps.html" target="_NEW"><b><font color="red">Free</font> to Students</b></a>. An Annual licence is $119/year and a Perpetual Licence is only $199. </td> <td valign="top"><font color="blue" face="Verdana" size="2">A <b><font color="red">Free</font></b> <a href="https://web.archive.org/web/20220207025337/http://astah.net/editions/community" target="_NEW">Community version</a> is available. <br>Astah is a total System Design tool supporting UML, ERD,DFD, Flowchart, Mind Map, CRUD and Requirement diagrams) <!----- , and they publish a lot of very favourable User Comments in <A HREF="http://jude.change-vision.com/jude-web/voice.html" TARGET=_NEW>their Community Forum</A>. -----> <!----- Follow them on <A HREF="Follow us on Twitter! http://twitter.com/#!/astah_en" TARGET=_NEW>Twitter</A> ------> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.azzurri.jp/en/software/clay/index.jsp" target="_NEW">Azzurri Clay</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.azzurri.jp/en/" target="_NEW"><font color="blue" face="Verdana" size="2">Azzuri (Japan)</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red"><b>Free</b></font></td> <td valign="top"><font color="blue" face="Verdana" size="2">From <b>Japan</b> -Open Source Plug-In for Eclipe - Reverse Engineering and generates SQL. <br>Pro version costs 35,000 Japanese Yen (about $150) !! </td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.borland.com/en-GB/Products/Requirements-Management/Together" target="_NEW">Borland Together</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.borland.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">Borland</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">No prices on the Website</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">Offers UML but not ERDs - Described as "Visual Modeling for Software Architecture Design". <br>The Website offers information on <a href="https://web.archive.org/web/20220207025337/http://www.borland.com/us/rc/model-driven-development/index.html" target="_NEW"> <font color="red">Model-Driven Development</font></a>. </td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.ca.com/us/products/product.aspx?id=256" target="_NEW">CA Gen</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.ca.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">Computer Associates</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">No prices on the Website</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">Provides Model-Driven support for <b>Agile Development</b>. Has a UK Partner in <a href="https://web.archive.org/web/20220207025337/http://www.response-systems.com/" target="_NEW">Response Systems</a>. </td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.casestudio.com/" target="_NEW">Case Studio 2</a> Acquired by Toad (see below under Toad Data Modeler)</td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.charonware.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">CharonWare</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2"><font color="red">Free</font>Download Trial, then $175(Lite) or $369(Full)</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">Looks impressive - supports an unusally wide range of Databases, including Firebird, MaxDB,Postgres - if you try it, please me have <a href="https://web.archive.org/web/20220207025337/mailto:comments_on_studio2@databaseanswers.org">your comments</a>. <br>Here's <a href="#DAN_HORN">a "5-Star" Review from Dan Horn.</a></td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.casewise.com/" target="_NEW">CASEWise</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.sybase.com/home/" target="_NEW"><font color="blue" face="Verdana" size="2">CASEWise</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">Aimed at Business Process Modelling, but has links to DataArchitect.</td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.conceptdraw.com/en/products/cd5/applications_uml.php" target="_NEW">ConceptDraw</a> </td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.csodessa.com/" target="_NEW"><font color="blue" face="Verdana" size="2">CS Odessa</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">$179 (50% off)</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">For <b>ERD, UML, ORM, FlowCharts, etc.</b> - Free Download Trial is available.</b> I like the appearance of the diagrams this Product produces and this is an important consideration for me. </td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.sybase.com/products/modelingdevelopment/powerdesigner">DataArchitect</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.sybase.com/home/" target="_NEW"><font color="blue" face="Verdana" size="2">Sybase</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">$2,000</td> <td valign="TOP"><font color="blue" face="Verdana" size="2"><b>If you are buying for the company, buy this one.</b> <font size="2"><br>DataArchitect is part of Power Designer, which is described below.</td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a hreeeef="http://www.thekompany.com/products/dataarchitect/index.php3" target="_NEW">DataArchitect</a></td> <td valign="TOP"><a hreeeef="http://www.thekompany.com/" target="_NEW"><font color="blue" face="Verdana" size="2">TheKompany</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">This product has disappeared - thanks to <b>Matthijs Willemstein</b> for letting me know. <br>If you have any news or suggestions for replacements, <a href="https://web.archive.org/web/20220207025337/mailto:dba_requests@barryw.org">please let me know</a>. </tr> <!---------------------- <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://gnuwin.epfl.ch/apps/DDT/en/" TARGET=_NEW>Database Design Tool (DDT)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> THANKS VERY MUCH to <A HREF="http://www.bosh.info" TARGET=_NEW><B>Josh Bosh</B></A>, Milwaukee's most beloved Web specialist, for providing this link. </TD> </TR> ---------> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.chillisource.com/dds/index.html"> Database Design Studio</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.chillisource.com/"><font color="blue" face="Verdana" size="2">Chilli Source</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://download.cnet.com/Database-Design-Studio-Lite/3000-10254_4-10027666.html" target="_NEW">Lite</a> at $80 , <a href="https://web.archive.org/web/20220207025337/http://download.cnet.com/Database-Design-Studio-Professional/3000-10254_4-10261065.html" target="_NEW">Professional</a> at $299. and <b>maybe</b> Educational at $39. </td> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://download.cnet.com/Database-Design-Studio-Lite/3000-10254_4-10027666.html" target="_NEW">Lite</a> supports ERD Modeling and Forward Engineering and <a href="https://web.archive.org/web/20220207025337/http://download.cnet.com/Database-Design-Studio-Professional/3000-10254_4-10261065.html" target="_NEW">Professional</a> adds support for Reverse Engineering. </td> </tr> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.microolap.com/products/database/postgresql-designer/" target="_NEW">Database Designer</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.microolap.com/" target="_NEW"><font color="blue" face="Verdana" size="2">MicroOlap</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$125</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">Specially for <b>PostgreSQL</b> and includes Reverse Engineering.They give it away <b><font color="red">Free</font></b> if you mention it in your Blog. </td> </tr> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.dbconstructor.com/home/home.aspx" target="_NEW">DB Constructor</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.dbconstructor.com/home/home.aspx" target="_NEW"><font color="blue" face="Verdana" size="2">Robert Schambach</td> <td valign="top"><font color="blue" face="Verdana" size="2"><font size="2">Free/$150</td> <td valign="top"><font color="blue" face="Verdana" size="2">Here's <font color="red">a glowing reference</font> at the <a href="https://web.archive.org/web/20220207025337/http://www.freedownloadscenter.com/Information_Management/Information_Refere nce_Databases/dbConstructor___Your_Database_Tool__Review.html" target="_NEW">FreeDownloadCenter Web Site</a>. </td> </tr> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.fabforce.net/dbdesigner4/" target="_NEW"> DBDesigner 4</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.fabforce.net/" target="_NEW"><font color="blue" face="Verdana" size="2">FabForce.net</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font><font size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.fabforce.net/dbdesigner4/donations.php" target="_NEW">(Donations welcome)</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Open Source and <b>highly recommended</b> if you work with <b>MySQL</b>. </td> </tr> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://sourceforge.net/projects/dbdesigner-fork/" target="_NEW"> DBDesigner-Fork</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.sourceforce.net/" target="_NEW"><font color="blue" face="Verdana" size="2">SourceForce.net</a> </td> <td valign="top"><font color="red" face="Verdana" size="2">Free</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">A Fork of <b>DBDesigner 4</b> (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBird. </td> </tr> <!------------------ <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.primelogics.com/primevision.htm" TARGET=_NEW>DB Diagram Designer</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.primelogics.com/" TARGET=_NEW>PrimeLogics</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Offers a Free evaluation download or $130 to buy.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>Looks very interesting</B> - modeller plus data editor using ODBC connections. If you try it please let me know <A HREF="mailto:barryw@databaseanswers.com" TARGET=_NEW><B>your opinion</B>.</A></B></TD> </TR> ----> <!--- <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbesoftware.com/" TARGET=_NEW>DB Examiner</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbesoftware.com/" TARGET=_NEW>DBE Software Inc.</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free Trial</FONT> but I was not able to find prices quoted on their Web Site.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks interesting and offers unique facilities for validation of a Data Model. </TD> </TR> ---> <hr> <tr> <td valign="top" width="200"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/https://www.devart.com/dbforge/mysql/studio/" target="_NEW"> DBForge for MySQL</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.devart.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Devart</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red"></font><font size="2"> <a href="https://web.archive.org/web/20220207025337/https://www.devart.com/purchase.html" target="_NEW">From $59.95</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><b> <!--------- Recommended for</B> the <B>Cloud Drivers</B> and range of tools if offers if you work with <B>SQL Server. <HR> --------------> dbForge Studio for MySQL</b> offers a universal MySQL and MariaDB client for database management, administration and development. With the help of this intelligent MySQL client the work with data and code has become easier and more convenient. <br>Devart's MySQL GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, <br>and gives possibility to analyze and report MySQL tables data. <hr></b> Here's an example of a DB Forge Data Model :- <br><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/dbforge_screenshot.jpg"> </td> </tr> <hr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.db-main.eu/?q=en" target="_NEW">DB Main</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.rever.eu/rever_new/en" target="_NEW">Rever</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> for the Data Modeller, with add-ons available at typical prices of 1,000 Euros or US Dollars.</td> <td valign="top"><font color="blue" face="Verdana" size="2">Produced in Belgium, with documentation <b>in English and French</b>. <br>Offers a very impressive range of features, including :- <br>"... meta-modeling components that allow its users to develop new functions and <b>extend its repository</b>" </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.dbschema.com/" target="_NEW">DBSchema</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.dbschema.com/" target="_NEW">Concrete Software, Romania</a></td> <td><font color="blue" face="Verdana" size="2">Free download and then <b>only $45</b> to buy.</td> <td valign="top"><font color="blue" face="Verdana" size="2"><b>Reverse Engineer Oracle</b> and other Databases using JDBC connections. <br>Can also generate SQL to create Databases from a Data Model. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.dbvis.com/products/dbvis/" target="_NEW">DBVisualiser</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.dbvis.com/" target="_NEW">Minq</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free evaluation and then <b>only $129</b> to buy,($103 for Education).</td> <td valign="top"><font color="blue" face="Verdana" size="2"> Helpful for <b>DBA</b> work, like performance monitoring. <br>A Finalist for 'Best Data Access Tool 2005' in the Java Developers Journal Readers Choice Award and included in the BEA WebLogic Workshop. <br><b><font color="red">Free</font></b> version available with "the basic level of features that most users require".</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.dbwrench.com/" target="_NEW">DB Wrench</a> <!--- <IMG BORDER=0 SRC="images/dbwrench_logo.jpg"></A> ---> <!--- <B><I>db</I></B>Wrench</A> ---> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.nizana.com/" target="_NEW">Nizana</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$149</td> <td valign="top"><font color="blue" face="Verdana" size="2"> "Forward and Reverse Engineer, Affordable, Easy to Use." </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.datanamic.com/dezign/index.html" target="_NEW">Dezign</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.datanamic.com/" target="_NEW">Datanamic</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Offers a Free download or starts at $259 to buy.</td> <td valign="top"><font color="blue" face="Verdana" size="2">A recent upgrade offers significantly improved features. <br>Supports Forward and Reverse Engineering for about 20 different Databases. <br><b>If you are buying for yourself, buy this one</b> <hr> Here's an example of a Dezign Data Model :- <br><img src="/web/20220207025337im_/http://www.databaseanswers.org/data_models/universal_data_model/images/data_model.gif"> </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.gnome.org/projects/dia/" target="_NEW">Dia</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sourceforge.net/index.php" target="_NEW"> Hosted by Sourceforge</a></td> <td><font color="blue" face="Verdana" size="2"><font color="red">Free</font> - Contributions suggested</td> <td><font color="blue" face="Verdana" size="2">"Dia is software for drawing diagrams similar to Visio", such as UML. It's Open Source with many authors. <a href="https://web.archive.org/web/20220207025337/http://dia-installer.sourceforge.net/" target="_NEW">Install it from here</a> </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://druid.sourceforge.net/" target="_NEW"> Druid</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.sourceforge.net/" target="_NEW"> From SourceForge</a></td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td><font color="blue" face="Verdana" size="2">Generates SQL Scripts and Java classes. <br>Thanks again to <b>Josh Bosh</b>.</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://sparxsystems.com.au/" target="_NEW">Enterprise Architect</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sparxsystems.com.au/" target="_NEW">Sparx Systems</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.sparxsystems.com/products/ea/trial.html" target="_NEW">Free Download</a> - then $135 to $239</td> <td><font color="blue" face="Verdana" size="2">From Australia - supports <b>UML</b> and very affordable, and has an entry in <a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/Enterprise_Architect_(software)#Data_modeling" target="_NEW"><b>Wikipedia</b></a>. </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.ideablade.com/products_summary.html" target="_NEW&quot;"> Entity Framework Add-on</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.ideablade.com/" target="_new"> IdeaBlade</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$995+/developer</td> <td valign="top"><font color="blue" face="Verdana" size="2">"Makes Microsoft's Entity Framework easier to use"</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://soft-builder.com/en/erone-data-modeler/" target="_NEW">ER One</a> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/new.gif"></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://soft-builder.com/en/"><font color="blue" face="Verdana" size="2">Soft Builder</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">Sample of a Data Model <br> <!-------- <IMG WIDTH=600 SRC="http://soft-builder.com/en/wp-content/uploads/examples/CarPartsSuppliers.jpg"> -----> <img wiiiidth="600" src="/web/20220207025337im_/http://www.databaseanswers.org/images/er_one_acreenshot.jpg"> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.modelcreator.com/" target="_NEW">ER Creator</a></td> <td><a hreef="http://www.cai.com"><font color="blue" face="Verdana" size="2">Model Creator</a></td> <td><font color="blue" face="Verdana" size="2">About $100</td> <td valign="top"><font color="blue" face="Verdana" size="2">Includes a Tutorial and a Trial version.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.keeptool.com/" target="_NEW">ER Diagrammer</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.keeptool.com/" target="_NEW"><font color="blue" face="Verdana" size="2"> KeepTool</a></td> <td><font color="blue" face="Verdana" size="2">$240</td> <td valign="top"><font color="blue" face="Verdana" size="2">Free download is available and a User Forum is supported.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.erdconcepts.com/" target="_NEW">ERD Concepts 5</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.erdconcepts.com/" target="_NEW"><font color="blue" face="Verdana" size="2"> ERD Concepts</a></td> <td><font color="blue" face="Verdana" size="2">$179 Euros (single-user)</td> <td valign="top"><font color="blue" face="Verdana" size="2">A Free download is available.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.embarcadero.com/products/er-studio" target="_NEW">ER/Studio</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.embarcadero.com/"><font color="blue" face="Verdana" size="2">Embarcadero</a></td> <td><font color="blue" face="Verdana" size="2">$1,500 up to $7,500 (!!!)</td> <td valign="top"><font color="blue" face="Verdana" size="2">In response to a helpful comment from <b>Daryl Purcell</b> I have added a link to <a href="https://web.archive.org/web/20220207025337/http://shop.embarcadero.com/dr/v2/ec_Main.Entry17c?SID=39696&amp;SP=10024&amp;CID=0&amp;PID=&amp;PN=29&amp;V1=31048725&amp;V2=31048725&amp;CUR=840&amp;DSP=&amp;PGRP=0&amp;ABCODE=&amp;CACHE_ID=0" target="_NEW"> US prices</a> and <a href="https://web.archive.org/web/20220207025337/http://store.embarcadero.com/DRHM/store?Action=DisplayCategoryProductListPage&amp;SiteID=borlande&amp;Locale=en_GB&amp;categoryID=13829500" target="_NEW"> UK prices</a>. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.erwin.com/" target="_NEW">ERwin</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.cai.com/" target="_NEW"><font color="blue" face="Verdana" size="2">CA Technologies</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">There is <a href="https://web.archive.org/web/20220207025337/http://erwin.com/products/detail/ca_erwin_data_modeler_community_edition/" target="_NEW"><font color="blue" face="Verdana" size="2"> a <b>Free</b> Community Edition</a>, and a price list is in <a href="https://web.archive.org/web/20220207025337/http://shop.erwin.com/" target="_NEW">the Online Store</a>. </td> <td valign="top"><font color="blue" face="Verdana" size="2">One of the Market Leaders - an enterprise solution with a particularly powerful Model Manager for large teams, especially useful when operating from different locations. <hr> Here's an example of an ERwin Data Model :- <br><img src="/web/20220207025337im_/http://www.databaseanswers.org/data_models/canonical_data_models/images/data_model.gif"> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.electronic-experience.net/" target="_NEW">Experience</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.electronic-experience.net/" target="_NEW"><font color="blue" face="Verdana" size="2">Electronic Exerience</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Trial then 90 Euros (about $50)</td> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp; <!--- If you have any experience to pass on, <A HREF="mailto:happyfish_comments@databaseanswers.org">please tell me</A> if you have any experience with it. ---> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.codepatterns.com/a_aboutfasttracks.htm" target="_NEW">FastTracks</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.codepatterns.com/index.htm" target="_NEW"><font color="blue" face="Verdana" size="2">Code Patterns</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2">Works only with UML and Ruby on Rails</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.genmymodel.com/" target="_NEW">GenMyModel</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.genmymodel.com/" target="_NEW"><font color="blue" face="Verdana" size="2">GenMyModel</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><b>Free !!!</b> A beautiful Web Site</td> <td valign="top"><font color="blue" face="Verdana" size="2"> "GenMyModel is an innovative online UML tool for software architects and developers. <br>It allows to create UML-compliant diagrams, export and <b>generate code</b> from your web browser. <!--- <BR>Within GenMyModel you design real models, not only shapes and lines: your diagrams conform to UML and naturally generate code. <BR>GenMyModel has been developed by a team who are passionate about their work, using Javascript and HTML5. ---> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.gliffy.com/products/online/" target="_NEW">Gliffy</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a hreeeef="http://www.gliffy.com/products/online/" target="_NEW">Gliffy</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> option available</td> <td valign="top"><font color="blue" face="Verdana" size="2"> The <font color="red">ONLY Online Modelling Tool</font> I have found - unfortunately it only does UML at the moment. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://code.google.com/p/wwwsqldesigner/" target="_NEW">Google WWW SQL Designer</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a hreeeef="http://ondras.zarovi.cz/" target="_NEW">Ondrej Zara (Czechoslovakia)</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> Open Source</td> <td valign="top"><font color="blue" face="Verdana" size="2">Good-looking <a href="https://web.archive.org/web/20220207025337/http://ondras.zarovi.cz/sql/demo/?keyword=default" target="_NEW"><b>sample Data Model</a>. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.calopus.com/calopus/gteadata.htm" target="_NEW">G-TEA Data Architect</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.calopus.com/" target="_NEW">Calopus (UK)</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> Community version available</td> <td valign="top"><font color="blue" face="Verdana" size="2"> <b>An interesting and (currently) a unique Cloud-based Modelling Tool</a> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.erdconcepts.com/" target="_NEW">Happy Fish</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.polderij.nl/" target="_NEW"><font color="blue" face="Verdana" size="2">Polderij NV.</a> (in Dutch)</td> <td valign="top"><font color="blue" face="Verdana" size="2">$89</td> <td valign="top"><font color="blue" face="Verdana" size="2"> Renamed <a href="https://web.archive.org/web/20220207025337/http://www.erdconcepts.com/" target="_NEW">ERD Concepts</a>.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://objectgeneration.com/eclipse/index.html" target="_NEW">HiberObjects</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://objectgeneration.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Object Generation</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">An open source UML Tool for creating Class diagrams that supports Reverse Engineering</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www-01.ibm.com/software/data/studio/data-architect/features.html?S_CMP=wspace" target="_NEW"> IBM InfoSphere Data Architect</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.ibm.com/" target="_NEW"><font color="blue" face="Verdana" size="2"> IBM</a></td> <td><font color="blue" face="Verdana" size="2">$5,570 !!!</td> <td valign="top"><font color="blue" face="Verdana" size="2">Provides reverse and forward engineering facilities for a range of databases, also ERD and UML Modelling.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.datanamic.com/importermysql/index.html" target="_NEW">ImportER MySQL</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.datanamic.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Datanamic</a></td> <td><font color="blue" face="Verdana" size="2">Excellent value at $55</td> <td valign="top"><font color="blue" face="Verdana" size="2">Reverse Engineering for MySQL</td> </tr> <!--- http://www-01.ibm.com/software/data/studio/data-architect/features.html?S_CMP=wspace ----> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.mid.de/en/products/innovator-for-database-architects.html" target="_NEW">Innovator</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.mid.de/en/" target="_NEW"><font color="blue" face="Verdana" size="2">MID</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2">Free trial then no price details available</td> <td valign="top"><font color="blue" face="Verdana" size="2">Looks good. <br>It says it supports UML and ERD. <br>In the web site, it says :- <br>"With the addition of the IDEF1X-Notation also for Entity-Relationship-Models, Innovator is for the first time provided with a unified graphical presentation for both, the Entity-Relationship as well as the Data Base Diagrams." <hr> Here's an example of an Innovator Data Model :- <br><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/data_model_tool_examples/mid_innovator_feb22nd.jpg"> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.keeptool.com/en/keeptool_diagrammer.php" target="_NEW">KeepTool</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.keeptool.com/" target="_NEW"><font color="blue" face="Verdana" size="2">KeepTool</a> </td> <td><font color="blue" face="Verdana" size="2">$300 / 300 Euros</td> <td valign="top"><font color="blue" face="Verdana" size="2">Can Reverse Engineer Oracle Databases to create Data Models - Comments and experiences welcome.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.magicdraw.com/">MagicDraw</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.magicdraw.com/"><font color="blue" face="Verdana" size="2">No Magic</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2">Award-winning <b>UML Modeller</b> and very popular with Java enthusiasts.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.mega.com/_product/usisoa.htm" target="_NEW">Mega Database Builder</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.mega.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Mega</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2">Looks like a great product with a wide range of features BUT there is no price information on their Site and they offer an evaluation version but you can't download it - instead they will contact you to discuss your requirements !!! </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.modelright.com/" target="_NEW">ModelRight</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.modelright.com/" target="_NEW"><font color="blue" face="Verdana" size="2">ModelRight</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Trial, then $495 for DB2, Oracle and SQL Server, $295 for MySQL and PostgreSQL, and $195 for Access.</td> <td valign="top"><font color="blue" face="Verdana" size="2"> An enthusiastic user is David McKelvey from Richardson,Texas, who says  As a pure Database Physical Modeling Tool, nothing else comes close."</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://mysql.com/products/workbench/" target="_NEW"> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/mysql_logo_sml.gif">MySQL Workbench</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://mysql.com/" target="_NEW"><font color="blue" face="Verdana" size="2">MySQL</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> with MySQL (also Free)</td> <td valign="top"><font color="blue" face="Verdana" size="2"> Looks good and offers Reverse Engineering.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.navicat.com/en/products/navicat_datamodeler/modeler_overview.html" target="_NEW">Navicat Data Modeler</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.navicat.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Navicat</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="blue" face="Verdana" size="2">Starts at $79 for a non-commercial version</td> <td valign="top"><font color="blue" face="Verdana" size="2">Looks good with a comprehensive range of versions.</font></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://pgmodeler.com.br/" target="_NEW">pgModeler</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://pgmodeler.com.br/" target="_NEW">pgModeler from Brazil</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">$10</font></td> <td valign="top"><font color="blue" face="Verdana" size="2"> pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. <hr> Very impressive Web Site - offers 4 Social Networks <hr> "Combines ERD features with Postgres extensions". <br> <br>Here is a sample Model in pgModeller:- <br> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/pg_modeller_sml.jpg"> </td> </tr> <!---------- <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://homepage2.nifty.com/dbc/indexEn.html" TARGET=_NEW>X-TEA111111111111111</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://homepage2.nifty.com/dbc/indexEn.html" TARGET=_NEW>X-TEA</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Data Modelling Tool includes Data Model Slideshows, Dataflows and designs. <BR>Here is a sample Model :- <BR> <IMG SRC="images/X_TEA_from_Japan.jpg"> </TD> </TR> -------> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.objecteering.com/" target="_NEW">Objecteering</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.objecteering.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Objecteering.com</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red" face="Verdana" size="2">Free</font> download trial</td> <td valign="top"><font color="blue" face="Verdana" size="2">Looks good with a comprehensive range of features, including UML support.</font></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.omnigroup.com/products/omnigraffle/" target="_NEW">OmniGraffle</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.omnigroup.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Omni Group</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red" face="Verdana" size="2">Free</font> download trial</td> <td valign="top"><font color="red" face="Verdana" size="2">For Mac only</font></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.modelsphere.org/" target="_NEW">Open ModelSphere</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.omnigroup.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Model Sphere</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red" face="Verdana" size="2">Free</font> </td> <td valign="top"><font color="red" face="Verdana" size="2">Open Source and UML</font></td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://otn.oracle.com/products/designer/index.html" target="_NEW"> Oracle Designer</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.oracle.com/" target="_NEW"> Oracle</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$200</td> <td valign="top"><font color="blue" face="Verdana" size="2">Available from the <a href="https://web.archive.org/web/20220207025337/http://technet.oracle.com/" target="_NEW">Oracle Technology Network</a> (Free to join).</b> <br>Oracle says "Oracle Designer is our model-driven development tool based on the principles of Information Engineering."</td> </tr> <tr> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://otn.oracle.com/products/jdev/index.html" target="_NEW"> <font color="blue" face="Verdana" size="2">Oracle J-Developer</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://otn.oracle.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">Oracle</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Download</td> <td valign="top"><font color="blue" face="Verdana" size="2"><b>UML</b> diagramming is part of J-Developer. <br><font size="2">Also available from the <a href="https://web.archive.org/web/20220207025337/http://technet.oracle.com/" target="_NEW">Oracle Technology Network</a>. <br>Oracle says "Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services." </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html" target="_NEW"> Oracle SQL Developer Data Modeler</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.oracle.com/" target="_NEW"> Oracle</a></td> <td valign="top"><font color="red" face="Verdana" size="2">Free</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">Many thanks to <b>Tuomas Kassila in Finland</b> for telling us about this. <br>Oracle says :- <br>SQL Developer Data Modeler is a Free data modeling and design tool, for ERD and Multi-dimensional modeling, with forward and reverse engineering. It imports from and exports to a variety of sources and targets. <hr>In a discussion on LInkdedIn, <a href="https://web.archive.org/web/20220207025337/http://www.linkedin.com/profile/view?id=1823988&amp;authType=name&amp;authToken=h1Bz&amp;trk=miniprofile-primary-view-button" target="_NEW"><b>Kent Graziano</b></a> said :- <br> Oracle SQL Developer Data Modeler has a Logical Modeling diagrammer that gives you the option of three different notations and the ability to turn various display options on and off. <br>You also have an option to use box-in-box for sub types (if you like that style), so it is very usable. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.orm-designer.com/" target="_NEW">ORM Designer</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.inventic.cz/" target="_NEW">Inventic</a></td> <td><font color="blue" face="Verdana" size="2">Offers a Free trial then costs $140 or 99 Euros.</td> <td valign="top"><font color="blue" face="Verdana" size="2">Thanks to <b>Ludek Vodicka</b> in Czechoslovakia.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.hardgeus.com/projects/pgdesigner/" target="_NEW">PG Designer</a></td> <td><font color="blue" face="Verdana" size="2">From John.</td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2">Open Source - for PostgreSQL. <br>Thanks again to <b>Josh Bosh</b>.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.cai.com/products/decisionbase/repository.htm" target="_NEW"> Platinum Repository</a></td> <td><a href="https://web.archive.org/web/20220207025337/http://www.cai.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Computer Associates</a></td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2"> This is a Repository, rather than a Modelling Tool, with a 'Where-used' facility, and it lets you add entity types,such as Business Function, Business Role and Script. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/https://editor.ponyorm.com/" target="_NEW">Pony ORM</a> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/new.gif"></td> <td><a href="https://web.archive.org/web/20220207025337/https://editor.ponyorm.com/" target="_NEW"><font color="blue" face="Verdana" size="2">Pony</a></td> <td><font color="blue" face="Verdana" size="2">No price details available - in fact no details of any sort.</td> <td valign="top"><font color="blue" face="Verdana" size="2"> A very happy User says "a fantastic data modelling tool" <!------- Comes highly recommended, good for <B>UML</B>, and has an open-source <FONT COLOR=red>Free</FONT> version. -----------> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.gentleware.com/" target="_NEW">Poseidon</a></td> <td><a href="https://web.archive.org/web/20220207025337/http://www.gentleware.com/" target="_NEW"><font color="blue" face="Verdana" size="2">GentleWare</a></td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2"> Comes highly recommended, good for <b>UML</b>, and has an open-source <font color="red">Free</font> version. </td> </tr> <!----- <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sqlpower.ca/page/architect" TARGET=_NEW>SQL Power Architect</A></TD> <TD VALIGN=TOP><A HREF="http://wwww.sqlpower.ca/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>SQL Power</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> (Open Source)</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp <HR> Here's an example of an SQL Power Data Model :- <BR><IMG SRC="images/data_model_tool_examples/sqlpower_data_model_feb22nd.jpg"> </TD> </TR> -----> <a name="POWER_DESIGNER"></a> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.sybase.com/products/designtools/powerdesigner/" target="_NEW">Power Designer</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.sybase.com/home/" target="_NEW"><font color="blue" face="Verdana" size="2">Sybase</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">$2,000</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">If you are buying for the company, consider this one. </td> </tr> <tr> <td valign="top"><font color="red" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.metastorm.com/products/provision_ea.asp" target="_NEW">ProVision</a> now renamed to <a href="https://web.archive.org/web/20220207025337/http://www.bps.opentext.com/" target="_NEW">OpenText</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.metastorm.com/" target="_NEW"><font color="blue" face="Verdana" size="2">MetaStorm</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Trial, but prices not avalable on the Website.</td> <td valign="top"><font color="blue" face="Verdana" size="2"> Includes Frameworks, such as Zachman, and also Reference Models, such as Customers, Finance and Telecomms, and an interesting <a href="images/MetaStorm_ProVision_lge.jpg" target="_NEW"><img border="0" src="/web/20220207025337im_/http://www.databaseanswers.org/images/MetaStorm_ProVision_xsml.jpg"><b>3-D Architecture</b></a> </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://revj.sourceforge.net/" target="_NEW">RevJ</a></td> <td><a href="https://web.archive.org/web/20220207025337/http://revj.sourceforge.net/" target="_NEW"><font color="blue" face="Verdana" size="2">SourceForge</a></td> <td><font color="blue" face="Verdana" size="2"><font color="red"><b>Free</b></font> Open Source</td> <td valign="top"><font color="blue" face="Verdana" size="2"> This Object Source product generates ERD Data Models from SQL. It is a way of understanding complex SQL that you might have 'inherited' from somebody else. <br>Please <a href="https://web.archive.org/web/20220207025337/mailto:dba_requests@barryw.org?subject=Comments on RevJ">Email me</a> if you have any comments on <b>RevJ</b>. </td> </tr> <!--- <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.quest.com/qdesigner/" TARGET=_NEW> QDesigner</A></TD> <TD VALIGN=top><A HREF="http://www.quest.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Quest.</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=1>Pricing difficult to find on the Quest Web Site</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=1>From the 'Toad Company' - looks good and is well-recommended by at least one satisfied user - a downloadable Trial is available(rather substantial at at 63MB). </TD> </TR> ---> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.rhalotel.com/web-database-diagram-manager-demo.html" target="_NEW">Rhalotel DB Diagram Mgr</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.rhalotel.com/" target="_NEW"> <pre><font color="blue" face="Verdana" size="2">Rhalotel</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">98 Euros/$100</td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.byterefinery.com/produkte" target="_NEW">RM Bench</a></td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.byterefinery.com/" target="_NEW"> <pre><font color="blue" face="Verdana" size="2">Byte Refinery</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Trial then $120</td> <td><font color="blue" face="Verdana" size="2">"Graphical Modelling of Relational Databases in Eclipse".</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.silwoodtechnology.com/products/" target="_NEW">Safyr</a> </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.ca.com/" target="_NEW"> <pre><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.silwoodtechnology.com/" target="_NEW">Silwood</a></pre></td> <td valign="top"><font color="blue" face="Verdana" size="2">Used to be about $14,000 but check with Silwood</td> <td><font color="blue" face="Verdana" size="2">Safyr is <b>more than a Modelling Tool</b>. It sits between an ERP like SAP and a Modelling Tool like ERWin. <br> It provides a very useful and powerful <b>Metadata manipulation</b> package which allows you to extract metadata from ERPs such as SAP, Salesforce, J.D. Edwards, PeopleSoft, Siebel and Oracle E-Business Suite which can then be 'reverse engineered' into a Modelling Tool like ERwin, to see the Data Model.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://schemaspy.sourceforge.net/" target="_NEW">Schema Spy</a> (command line) or <a href="https://web.archive.org/web/20220207025337/http://www.joachim-uhl.de/projekte/schemaspygui/" target="_NEW">Schema Spy GUI (Point and click) </td> <td valign="top"><a hreeeef="http://www.silverrun.com/index.html" target="_NEW"> <pre><font color="blue" face="Verdana" size="2">Schema Spy</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free</td> <td valign="top"><font color="blue" face="Verdana" size="2">May not exactly be a Data Modelling Tool. <br>On the Web Site, it is described as a "Graphical Database Schema Metadata Browser" and a tool to investigate the validity of a Data Model. <br><br>The Web Site also says :- <br>"Do you hate starting on a new project and having to try to figure out someone else's idea of a database? <br>Or are you in QA and the developers expect you to understand all the relationships in their schema? <br>If so then this tool's for you. <br><br>A Contributor to the LinekdIn Data Architecture Group said :- <br>"Schemaspy would be nice for Reverse Engineering as it outputs in HTML and you can zip the file and send it around to people. <br<a contributgion on the linkedin data architecure group said :- <br>"I have used to to view what is inside a schema, quickly. <br>It helps you to quickly generate the data model and visualize entities as per 'Degree of Separation' , too. <br>Very flexible, and quick, it is just a 'jar' file to which you pass your database credentials and it does the job. </td> <!--- Highly recommended by <B>Beth in San Francisco</B> on June 26th. 2007. ---> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.silverrun.com/modelsphere_dm.html" target="_NEW">SilverRun Data Modeller</a> (now Open ModelSphere) </td> <td valign="top"><a href="https://web.archive.org/web/20220207025337/http://www.silverrun.com/index.html" target="_NEW"> <pre><font color="blue" face="Verdana" size="2">Grandite</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$990 <!--- Offered on a unique Buy or Rent Scheme ($1,500/year). <BR><FONT SIZE=2>But the Web Site says 'Please contact us for a customized quote' - which often means 'If you have to ask, you can't afford it'. ---> </td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <!--- Highly recommended by <B>Beth in San Francisco</B> on June 26th. 2007. ---> </tr> <!--------- <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sisense.com/product/" TARGET=_NEW>Sisense</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.sisense.com/company/" TARGET=_NEW>Sisense</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$ Available on demand - usually means it's expensive, as in -'If you have to ask, you can't afford it'</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Looks like multiple products with mutiple features.</TD> </TR> ----------> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.smartdraw.com/resources/examples/software/erd.htm" target="_NEW">SmartDraw</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.smartdraw.com/" target="_NEW">SmartDraw</a></td> <td><font color="blue" face="Verdana" size="2">$50 !!!</td> <td><font color="blue" face="Verdana" size="2"><b>Recommended</b> - Promoted as a UML Drawing Tool with impressive support.</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://sparxsystems.com.au/" target="_NEW">Sparx Enterprise Architect</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sparxsystems.com.au/" target="_NEW">Sparx Systems</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.sparxsystems.com/products/ea/trial.html" target="_NEW">Free Download</a> - then $135 to $239</td> <td><font color="blue" face="Verdana" size="2">From Australia - supports <b>UML</b> and very affordable, and has an entry in <a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/Enterprise_Architect_(software)#Data_modeling" target="_NEW"><b>Wikipedia</b></a>. </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www-01.ibm.com/software/analytics/spss/products/modeler/" target="_NEW">SPSS Clemetine</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.ibm.com/" target="_NEW">IBM</a></td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td><font color="blue" face="Verdana" size="2"><b>IBM recommends this for Data Mining.</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://sqldeveloper.solyp.com/screenshots/diagram-editor/index.html" target="_NEW">SQL Developer Diagram Editor</a></td> <td><font color="blue" face="Verdana" size="2">&nbsp;</td> <td><font color="red" face="Verdana" size="2"><b>Free</b></font></td> <td><font color="blue" face="Verdana" size="2">Not to be confused with Oracle's SQL Developer. <br>Offers a range of attractive features and has some <a href="https://web.archive.org/web/20220207025337/http://sqldeveloper.solyp.com/reviews/index.html" target="_NEW">glowing references</a>. </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.sqlmaestro.com/" target="_NEW">SQL Maestro</a></td> <td><font color="blue" face="Verdana" size="2"><a hreeef="http://sourceforge.net/index.php" target="_NEW">SQL Maestro Group</a></td> <td><font color="blue" face="Verdana" size="2"><b><font color="red">Free</font>ware</b></td> <td><font color="blue" face="Verdana" size="2"><b>Please let me know if you have any experience with this product.</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.sqlmanager.net/" target="_NEW">SQL Manager</a></td> <td><font color="blue" face="Verdana" size="2"><a hreeef="http://sourceforge.net/index.php" target="_NEW">EMS</a></td> <td><font color="blue" face="Verdana" size="2"><b>Free Trial available</b></td> <td><font color="blue" face="Verdana" size="2"><b>&nbsp;</td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.sqlpower.ca/page/architect" target="_NEW">SQL Power Architect</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://wwww.sqlpower.ca/" target="_NEW"><font color="blue" face="Verdana" size="2">SQL Power</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> (Open Source)</td> <td valign="TOP"><font color="blue" face="Verdana" size="2"> Here's an example of an SQL Power Data Model :- <br><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/data_model_tool_examples/sqlpower_model_sml_feb22nd.jpg"> </td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://squirrel-sql.sourceforge.net/" target="_NEW">Squirrel</a></td> <td><font color="blue" face="Verdana" size="2"><a hreeef="http://sourceforge.net/index.php" target="_NEW">Squirrel</a></td> <td><font color="red" face="Verdana" size="2"><b>Free</b></td> <td><font color="blue" face="Verdana" size="2">Open Source</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://staruml.sourceforge.net/" target="_NEW">StarUML</a></td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sourceforge.net/index.php" target="_NEW">SourceForge</a></td> <td><font color="red" face="Verdana" size="2"><b>Free</b></td> <td><font color="blue" face="Verdana" size="2"><b>"The Open Source UML/MDA Platform" (from Korea).</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www-01.ibm.com/software/awdtools/systemarchitect/">System Architect</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.ibm.com/">IBM</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$3,000-5,000 per seat.</td> <td valign="top"><font color="blue" face="Verdana" size="2">In an evaluation, I found this product very difficult to use, the diagrams were very ugly and it crashed too often for me to recommend it. <a href="https://web.archive.org/web/20220207025337/http://www.popkin.com/services/downloads/downloads.htm" target="_NEW">Downloads available for Evaluation.</td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.quest.com/toad_data_modeler" target="_NEW">Toad Data Modeler</a> </td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.quest.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">Quest</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.toadsoft.com/toaddm/toad_data_modeler.htm" target="_NEW">Free Download</a>, then $479</td> <td valign="TOP"><font color="blue" face="Verdana" size="2"><b>Price is 30% off</b> to CASE Studio 2 customers <br>From the makers of <b>Toad</b>, and based on CASE Studio 2  Includes 24x7 support, runs on over 40 DBMSs, and you can create ER &amp; Data Flow diagrams, reverse engineer and generate SQL Scripts.</td> </tr> <tr> <td valign="TOP"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.borland.com/en-GB/Products/Requirements-Management/Together" target="_NEW">Together (from Borlande)</a></td> <td valign="TOP"><a href="https://web.archive.org/web/20220207025337/http://www.borland.com/" target="_NEW"> <font color="blue" face="Verdana" size="2">Borland</a></td> <td valign="TOP"><font color="blue" face="Verdana" size="2">No prices on the Website</td> <td valign="TOP"><font color="blue" face="Verdana" size="2">Offers UML but not ERDs - Described as "Visual Modeling for Software Architecture Design". <br>The Website offers information on <a href="https://web.archive.org/web/20220207025337/http://www.borland.com/us/rc/model-driven-development/index.html" target="_NEW"> <font color="red">Model-Driven Development</font></a>. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://wwwhome.cs.utwente.nl/~tcm/" target="_NEW"> Toolkit for Conceptual Modeling (TCM)</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://wwwhome.cs.utwente.nl/" target="_NEW">University of Twente, Holland</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> and Downloadable</td> <td valign="top"><font color="blue" face="Verdana" size="2">Very interesting combination of Tools, including <b>UML</b>. <br>Thanks to <b>Tony Adams</b> for suggesting a better link here. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://uml.sourceforge.net/index.php" target="_NEW">Umbrello</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://sourceforge.net/" target="_NEW">SourceForge</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font> Open Source</td> <td valign="top"><font color="blue" face="Verdana" size="2">UML Modeller</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.microsoft.com/office/visio/" target="_NEW">Visio</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.microsoft.com/" target="_NEW">Microsoft</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Trial CD available</td> <td valign="top"><font color="blue" face="Verdana" size="1">Many Versions- Standard($199),Technical($399),Professional($399) and Enterprise($999)</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.visual-paradigm.com/" target="_NEW">Visual Paradigm</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.visual-paradigm.com/" target="_NEW">Visual Paradigm</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free Community Edition, also Free trial.</td> <td valign="top"><font color="blue" face="Verdana" size="2">Produced by a Hong Kong-based company - supports ERDs and UML, imports Visio</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.vertabelo.com/" target="_NEW">Vertabelo</a> </td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.vertabelo.com/" target="_NEW">Vertabelo</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">Free trial and then $12 or $48/month - $99 or $399.</td> <td valign="top"><font color="blue" face="Verdana" size="2">"Design your database <font color="red">Online</font>"</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://product-support.web.cern.ch/product-support/sdt/visualthought.html" target="_NEW">Visual Thought</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.cern.ch/" target="_NEW">CERN</a> (Godfathers of the Internet)</td> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp;</td> <td valign="top"><font color="blue" face="Verdana" size="2">Give it a try for <b>UML</b>. <br>THANKS AGAIN to <a href="https://web.archive.org/web/20220207025337/http://www.bosh.info/" target="_NEW"><b>Josh Bosh</b></a>, Milwaukee's most beloved Web specialist, for providing this link.</td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.excelsoftware.com/wina&amp;dproducts.html" target="_NEW">Win A&D;</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.excelsoftware.com/" target="_NEW">Excel Software</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">No price information on the Web Site</td> <td valign="top"><font color="blue" face="Verdana" size="2"><b>Unusually offers products for MAC</b> as well as Windows - <a href="https://web.archive.org/web/20220207025337/http://www.excelsoftware.com/uml_topic.html" target="_NEW"><b>UML</b> Modelling</a> as well as ERD. </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.xcase.com/" target="_NEW">xCase</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.xcase.com/" target="_NEW">Resolution Software</a></td> <td valign="top"><font color="blue" face="Verdana" size="2">$800 (Download Trial available)</td> <td valign="top"><font color="blue" face="Verdana" size="2"> "xCase is a complete database design and maintenance tool including archiving and model compare and merge across different DBMSs". </td> </tr> <tr> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://homepage2.nifty.com/dbc/indexEn.html" target="_NEW">X-TEA</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://homepage2.nifty.com/dbc/indexEn.html" target="_NEW">X-TEA</a></td> <td valign="top"><font color="blue" face="Verdana" size="2"><font color="red">Free</font></td> <td valign="top"><font color="blue" face="Verdana" size="2">Data Modelling Tool includes Data Model Slideshows, Dataflows and designs. <br>Here is a sample Model :- <br> <img src="/web/20220207025337im_/http://www.databaseanswers.org/images/X_TEA_from_Japan.jpg"> </td> </tr> </table> </center> <hr><a href="https://web.archive.org/web/20220207025337/http://en.wikipedia.org/wiki/Lady_Gabriella_Windsor" target="_NEW"> <img align="left" alt="Lady Gabriella Windsor, a Model (Click for Wikipedia entry)" border="1" width="130" height="187" src="/web/20220207025337im_/http://www.databaseanswers.org/images/gabriella_w_3.jpg"> </a> <center> <b>Useful Links :-</b> <br> <table border="1" cellpadding="5"> <tr> <td><font color="blue" face="Verdana" size="2"><b>CATEGORY</b></td> <td><font color="blue" face="Verdana" size="2"><b>ORGANISATION</b></td> <td><center><font color="blue" face="Verdana" size="2"><b>COMMENTS</b></td> </tr> <tr> <td><font color="blue" face="Verdana" size="2">Discussion Group</td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.infoadvisors.com/datamodellist.htm">InfoAdvisors</a></td> <td><font color="blue" face="Verdana" size="2">Data Model Group</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2">Portal</td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.infogoal.com/dmc/dmchome.htm">Data Management Centre</a></td> <td><font color="blue" face="Verdana" size="2"> <a href="https://web.archive.org/web/20220207025337/http://www.infogoal.com/dmc/dmcdmd.htm">Directory of Data Modelling Resources (Highly Recommended)</a></td> </tr> <tr> <td><font color="blue" face="Verdana" size="2">Portal</td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.dmreview.com/">DM Review</a></td> <td><font color="blue" face="Verdana" size="2">Search for 'Data Models'</td> </tr> <tr> <td><font color="blue" face="Verdana" size="2">Portal</td> <td><font color="blue" face="Verdana" size="2"><a href="https://web.archive.org/web/20220207025337/http://www.inconcept.com/JCM/">Journal of Conceptual Modelling</a></td> <td><font color="blue" face="Verdana" size="2">Worth Checking out</td> </tr> </table> </center> <a name="SHORT_NOTE"></a> <p><p><p><p><p><font color="blue" face="Verdana" size="2"> <hr> <b>A short note about about Data Modelling and Database Design ...</b> <pre><font color="blue" face="Verdana" size="2">Data modelling and database design are two very different activities. For data modelling, the question you are asking is : 1) What does the world being modelled look like ? In particular, you are looking for similarities between things. Then you identify a 'super-type' of thing which may have sub-types. For example, Corporate Customers and Personal Customers If, for example, supplier contacts are conceptually different things from customer contacts, then the answer is that they should be modelled separately. On the other hand, if they are merely sub-sets of the same thing, then treat them as the same thing. 2) For database design, you are answering a different question:- "How can I efficiently design a database that will support the functions of the proposed application or Web Site ?" The key task here is to identify similarities between entities so that you can integrate them into the same table, usually with a 'Type' indicator. For example, a Customer table, which combines all attributes of both Corporate and Personal Customers. As a result, it is possible to spend a great deal of time breaking things out when creating a Data Model, and then collapsing them back together when designing the corresponding database. </pre> <a name="DAN_HORN"></a> <pre><font color="blue" face="Verdana" size="2"> <b><i>Dan Horne writes about Case ...</i></b> "I have found Case Studio to be an outstanding tool in its market niche. It supports a wide variety of databases, although I've only use it with Oracle, where I have found it to be excellent. It's a bargain at $299, and with additional licenses costing only $89, it is well within the budget of most organizations that do not require an enterprise solution. I've been searching for a data modelling tool for some time, but most are not within my price range, and are generally aimed at larger companies. The competitive products I have found are marginally cheaper, but do not support the fundamental features I need such as the reverse engineering of existing databases. The only weakness is the documentation, which is included as a help file. Some topics such as exporting the diagrams to a graphic file are not covered, and there is no detail on writing templates to enhance and extend the system. Likewise, Data Flow Diagrams are barely touched on. <b>Nevertheless, I am very pleased with my purchase. Case Studio deserves to be much better known than it is.</b> Regards Dan Horne" </pre> <!-- Copyright Notice --> <br><center><font size="1"><i> &#169; DatabaseAnswers.org 2017</i></font></center></br> <!--- START OF APRIL 1ST. MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20220207025337im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20220207025337im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="5%" wiiiidth="6%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%" wiiiidth="10%"><a style="text-decoration:none" href="about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <td align="LEFT" width="8%" wiiiidth="18%"><a style="text-decoration:none" href="contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF APRIL 1ST. MENU BAR ---> </td></tr> </table> </body> </html> <!-- FILE ARCHIVED ON 02:53:37 Feb 07, 2022 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:18:40 Jun 27, 2023. JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. SECTION 108(a)(3)). --> <!-- playback timings (ms): captures_list: 176.188 exclusion.robots: 0.066 exclusion.robots.policy: 0.057 cdx.remote: 0.054 esindex: 0.009 LoadShardBlock: 135.762 (3) PetaboxLoader3.datanode: 154.201 (4) load_resource: 278.495 PetaboxLoader3.resolve: 212.698 -->