I did the same seach and evaluation a couple of weeks back. Ended up buying Dezign for Databases, partly on cost (compared to Case Studio which seems the most comprehensive product), but also because the evaluation version allowed enough tables/releationships to do a realistic eval + good documentation. Reverse engineering is possible if you buy the additional Importerscripts, or ImporterMysql, and you can define your own logical types (called domains) or additional Mysql types if the set is not complete. As far as I can see there is no way to define the table type, but the rest is covered. So far I'm finding it stable and very easy to work with.
Andy On 20 Oct 2002 at 19:07, Randy Garland wrote: > Hello, all: > > I'm looking for a well-designed Windows-based database design tool that: > > 1) (Most importantly) Supports MySQL 4.x: > a) supports all of its datatypes, including MEDIUMINT, ENUM, BLOB, AND > TEXT > b) lets the user decide between table types (ISAM v. InnoDB v BDB) > 2) Creates ERDs (Entity Relationship Diagrams) with standard 'crow's feet' > notation > 3) From the ERDs, generates 'load' and 'drop' sql scripts > 4) Can reverse engineer an existing MySQL database, creating an ERD from > the database > 5) Is, preferably, free or cheap > > I've looked and looked. I'm currently evaluating three products: > 1) Dezign for Databases (out of the Netherlands) > 2) CASE Studio version 2.10.1, by CHARONWARE (www.casestudio.com) > 3) Database Design Studio, by chillisource (www.chillisource.com) > > All of them are commercial, and I have reservations about each one. None is > MySQL-specific (they cover many db's), and as such, don't really make it > easy for the user to easily define MySQL-specific data types. Also, only > CASE includes Reverse Engineering. CASE is big bucks ($325), and the others > are in the $100 range. > > I just don't want to have to create my ERDs in Visio, document the details > in Excel, manually create scripts, and then have to update all three when > the db needs change. > > Is there one, good, unified tool for MySQL that can help? > > Thanks in advance, > Randy Garland > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
