Q: Data Modeling Tool for MySQL ???
Can anyone suggest a good data modeling tool that can be used for: a) Reverse enginering: dump file = data model b) Create a new data model c) Generate the ddl from the data model d) The tool should handle the latest features of MySQL 3.23.52 Any comments about the tool called dezign. Is it any good ?? Thanks Sri - 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
Re: Data modeling tool
On Wed, 14 Feb 2001, Dario Brignardello wrote: Hey! That's exactly what I'm working in... is your dia's parser GPLed ?? :-) It could help me a lot... Thanks in advance :-) I told folks at our local perl mongers ( http://norfolk.pm.org ) that I was working on packaging up what I had to send to you and someone pointed out that a dia to sql perl script already exists! http://www.karyopse.de/dia2sql/ I haven't tried it at all yet. I'd love to hear how people find it. -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - 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
Re: Data modeling tool
On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote: Moving back and forth is a manual process, which is a bit frustrating. Since dia stores everything in XML, I'm considering what it would take to make some sort of syncronization. I've been planning on looking into Alzabo too, which was already mentioned, but I haven't had the time for that either. :-( One feature I've been considering for Alzabo is to be able to somehow process dia's XML and generate a schema from it. Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML language Barrie Slaymaker is working on (with some input from me and others). If it is possible to transform from dia's XML to DBML and vice versa that would be extremely slick, I think. -dave /*== www.urth.org We await the New Sun ==*/ - 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
Re: Data modeling tool
On Wed, 14 Feb 2001, Dave Rolsky wrote: One feature I've been considering for Alzabo is to be able to somehow process dia's XML and generate a schema from it. Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML language Barrie Slaymaker is working on (with some input from me and others). If it is possible to transform from dia's XML to DBML and vice versa that would be extremely slick, I think. Bru-hahahahahaha! That'd be absolutely awesome. I'd be happy to tackle that once Alzabo's DBML support is ready. I've played with parsing dia's files a bit. Then we just have to get real-time hooks in dia so that there's no transformation required! :-) Bru-hahaha. -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - 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
Re: Data modeling tool
On Sat, 10 Feb 2001, Cal Evans [EMAIL PROTECTED] wrote: As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? I do my diagrams in UML with dia. And then I use mysqltool from Dajoba to build and maintain the tables: http://www.dajoba.com/projects/mysqltool/index.html?_of=20, Moving back and forth is a manual process, which is a bit frustrating. Since dia stores everything in XML, I'm considering what it would take to make some sort of syncronization. I've been planning on looking into Alzabo too, which was already mentioned, but I haven't had the time for that either. :-( -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - 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
RE: Data modeling tool [Long Rant and then some information]
Greetings list: I'm going to reply to my own message here. I've received 2 comments on my use of the word cartoonish when describing the interface to DeZign. While their approach was different, both basically wanted to know what I found cartoonish about the interface. First let me say that I will apologize for the use of the word cartoonish. It wasn't the best word to use, it was just the closest one that comes to mind. But it was not very accurate. Second, let me say that I won't apologize for my opinion, it's mine, if you don't like it, then get your own. Ok, I re-downloaded and re-installed DeZign.(http://www.heraut.demon.nl) For those who are not totally pissed at me now for my first faux-pas, I'll offer my opinion on the product. DeZign is a good product. I've worked with several ER diagramming programs in my 16 years of building databases and it's no where near the worst I've worked with. As a matter of fact, for the price (139.00US$) when compared to it's more "mature" brethren (ERWin, ER/Studio) it's a very good deal. However, there are several things that I personally did not like about. First, Most ER programs support a common paradigm for designing entities and attributes. Mainly that when you add an entity to the workspace, the entity is placed where you clicked. DeZign chooses to do it otherwise. It currently places all entities in the upper left corner. Also, it does not allow you to drag relationships between entities. It's a small thing but it's important when you are designing large models. (Also, I found it difficult to figure out how to do a 0:N relationship, which I consider the most common. It seems the default relationship is N:N A bit odd but nothing that a little poking around won't cure.) Finally, the interface breaks with the commonly used symbols for data modeling. Other tools use common symbols for entities and relationships. DeZign chose to use similar but non-standard symbols. All that said and done, what DeZign does have is a developer that actually cares how his product is perceived. (He reads this list!) There is nothing really wrong with DeZign. If you don't have a lot of experience with other E/R diagramming programs then you won't ever notice the things I'm talking about. But the thing you will notice about DeZign is that when you have a question, you actually get an email response from a person. That's refreshing these days. I hope I've not bored too many of you to tears. I'll go back to lurking now until another newbie questions comes along where I can help. Cal http://www.calevans.com p.s. my gripe about size limited demos still stands. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 11, 2001 9:36 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Data modeling tool Mark, I like CASE but I wish they would add MySQL Reverse Engineering capabilities to it. The interface is clean and similar to what one expects from it's more mature brothers. (ERWin, ER/Studio) A couple of people emailed me and told me to look at http://www.heraut.demon.nl but I'm not thrilled with the interface. It looks too cartoonish and as I remember it (it's been a month or more since I looked at it) it was not the friendliest program to work with. One gripe I have about both tools. I've done ER Diagramming "Bake Off's" before. I did one for tools that supported FoxPro a few years ago. With those tools, all the demo's were timed instead of size restrictive. I wish these two vendors would provide a 30-60 day demo that is unlimited. I can't get a feel for the tool with 6 tables. (Gees, my CHECKBOOK has more tables than that!) :) I'd love to publish a full comparison of the tools but these size limited demo's bite. Cal http://www.calevans.com -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Data modeling tool I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - 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.
RE: Data modeling tool
Mark, I like CASE but I wish they would add MySQL Reverse Engineering capabilities to it. The interface is clean and similar to what one expects from it's more mature brothers. (ERWin, ER/Studio) A couple of people emailed me and told me to look at http://www.heraut.demon.nl but I'm not thrilled with the interface. It looks too cartoonish and as I remember it (it's been a month or more since I looked at it) it was not the friendliest program to work with. One gripe I have about both tools. I've done ER Diagramming "Bake Off's" before. I did one for tools that supported FoxPro a few years ago. With those tools, all the demo's were timed instead of size restrictive. I wish these two vendors would provide a 30-60 day demo that is unlimited. I can't get a feel for the tool with 6 tables. (Gees, my CHECKBOOK has more tables than that!) :) I'd love to publish a full comparison of the tools but these size limited demo's bite. Cal http://www.calevans.com -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Data modeling tool I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - 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
RE: Data modeling tool
Thanks for the input. I like this tool better than the other 2. Other than the fact that it's reverse engineering can be easily broken and cannot infer relationships in the logical model it's a very nice tool. Same rant on size limited demos. At least with this one I can build larger models, I just can't save them. (Better than the other two but still not what I want) Cal http://www.calevans.com -Original Message- From: Michael Lpine [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 10:12 PM To: Cal Evans; [EMAIL PROTECTED] Subject: RE: Data modeling tool I asked a similar question recently and as a result of my searching, I found a moderately priced, $99 (I think), data modeling tool from XTG (download here): http://www.xtgsystems.com/download.php3 I downloaded it and set up a few tables (only 4 are allowed with eval), then generated the sequel to create one of the tables. I liked it but didn't go much further with it as I didn't want to pay for a modeling tool until I had tried a few more. Currently, I use Power Designer from Sybase which supports MySQL too but not as well as the modelling tool from XTG although it includes many more options, bells and whistles. You can download the eval and use it fully for 45 days. XTG - $99 (US) Power Designer - (approximately)$2000 (US) Try them for yourself and hopefully you'll like one. HTH, Mike -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:42 PM To: [EMAIL PROTECTED] Subject: Data modeling tool As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? Cal http://www.calevans.com - 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
RE: Data modeling tool
I agree that a time-limited, but otherwise fully functional demo is better, especially in the case (pardon the pun) of database modelling. It would certainly be worth sending them a message telling them so. You never know - they might agree with you. Mark Chalkley - 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
RE: Data modeling tool
Hi At 09:36 11/02/2001 -0600, Cal Evans wrote: Mark, I like CASE but I wish they would add MySQL Reverse Engineering capabilities to it. The interface is clean and similar to what one expects from it's more mature brothers. (ERWin, ER/Studio) A couple of people emailed me and told me to look at http://www.heraut.demon.nl but I'm not thrilled with the interface. It looks too cartoonish and as I remember it (it's been a month or more since I looked at it) it was not the friendliest program to work with. What is wrong with the interface? What do you mean cartoonish, Tom and Jerry don't all over my desktop? What is it that is not friendly? If you wish to criticize somebody else's work please, include a justification. As far as I am concerned Dezign does the job and is one hell of a lot cheaper. Also, FYI a Linux/UNIX version is planned. One gripe I have about both tools. I've done ER Diagramming "Bake Off's" before. I did one for tools that supported FoxPro a few years ago. With those tools, all the demo's were timed instead of size restrictive. I wish these two vendors would provide a 30-60 day demo that is unlimited. I can't get a feel for the tool with 6 tables. (Gees, my CHECKBOOK has more tables than that!) :) I'd love to publish a full comparison of the tools but these size limited demo's bite. Cal http://www.calevans.com -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Data modeling tool I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - 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 Regards John MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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
Re: Data modeling tool
I wish, ERWin is wonderful! - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 10, 2001 6:41 PM Subject: Data modeling tool As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? Cal http://www.calevans.com - 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
Re: Data modeling tool
I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - 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
Re: Data modeling tool
On Sat, 10 Feb 2001, Cal Evans wrote: As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? I have a project called Alzabo (alzabo.sourceforge.net) that is a combination data modeller/RBDMS-OO mapper (for Perl). The data modeller is web based (though I plan to eventually have other UIs) and requires Perl and HTML::Mason (www.masonhq.com). Currently it supports Mysql and Postgres, with the Mysql support being a bit more mature. -dave /*== www.urth.org We await the New Sun ==*/ - 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
RE: Data modeling tool
I asked a similar question recently and as a result of my searching, I found a moderately priced, $99 (I think), data modeling tool from XTG (download here): http://www.xtgsystems.com/download.php3 I downloaded it and set up a few tables (only 4 are allowed with eval), then generated the sequel to create one of the tables. I liked it but didn't go much further with it as I didn't want to pay for a modeling tool until I had tried a few more. Currently, I use Power Designer from Sybase which supports MySQL too but not as well as the modelling tool from XTG although it includes many more options, bells and whistles. You can download the eval and use it fully for 45 days. XTG - $99 (US) Power Designer - (approximately)$2000 (US) Try them for yourself and hopefully you'll like one. HTH, Mike -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:42 PM To: [EMAIL PROTECTED] Subject: Data modeling tool As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? Cal http://www.calevans.com - 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