I work with DeZign as well and chose it for basically the same reason as you. I particularly love the fact that it supports domains. I have been communicating with the author and encouraging him to add specific InnoDB table types.
I also suggested another feature to him that he really liked; we just have to come up with the right name for it. It's like a Domain except that it contains multiple columns, each defined like a Domain; for the moment I call it a meta-domain. For example, a meta-domain called CreditCardInfo would contain columns for CardNumber, CardHolder, ExpiryDate, DVV number and so on. Then you could add these columns to a table simply by adding the CreditCardInfo meta-domain to a table. Rick is considering it for inclusion in his next release. One other product I use is called dbScripter, from dkgAdvancedSolutions.com. It generates create and drop scripts as well as populate scripts for Oracle, Access and MySQL databases, using syntax profiles. I wrote a profile for MySQL that will be included in the next release. It costs around $95 US. An important feature that competitors do not have is the ability to create index scripts. Arthur -----Original Message----- From: Andy Blackshaw [mailto:support@;getme.co.uk] Sent: Monday, October 21, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: Re: ERD, Scripts, and Reverse Engineering 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 --------------------------------------------------------------------- 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