Hello!
Could you guys recommend some affordable SQL modeling tool which supports SQL Server, PostgreSQL and MySQL? I'm looking into up to $300 per license range. One tool per answer, please!
Thanks!
ERWin is well outside the quoted budget of $300
Dan Esparza
2010-08-26 23:22:32
A:
Some people I've worked with have had good things to say about TOAD - it works with Mysql, though not PostgreSQL. It is a free download and includes graphical modeling support.
Kyle Burton
2008-09-25 01:43:04
+1
A:
In addition to Microsoft Visio and SQL Server Database Diagrams, one tool not yet mentioned is EA Architect which can be purchased for under US$200.00
Mitch Wheat
2008-09-25 01:56:47
A:
This site has a run down of some of the tools available: http://www.databaseanswers.com/modelling_tools.htm.
I tried Dezign by Datanamic, which the site recommended for the individual user. It was pretty easy to use and has lots of features. It supports about 20 different databases to various degrees.
It has a free trial and the license is $245 for the Standard edition (not $139 as listed on the site). I ended up not buying it because I don't have any budget for tools but I would have if I did. If you need multiple licenses, the 5 and 10 packs offer a significant discount over the single-license fee.
Carlos Nunes-Ueno
2008-09-25 03:03:24
+2
A:
Keep an eye on SchemaBank, they are now at beta quality: just visual drawing of entity relationship, forward-engineering into SQL statements, versioning and simple sharing of your schema to others. And they seem to offer free accounts. For MySQL and PG only though.
Guess web-based database modeling is about to take off soon? They are SaaS vendor.
Leigh Pyle
2008-10-28 09:44:30
+2
A:
In fact, the most comprehensive list on database modeling / design tool would be from wikipedia.
Boyd Herkel
2009-10-08 02:43:09