ER Studio
Hi, I have used Er Studio to do my data modelling for a DB I am working on, and now I would like to generate a MySQL DB from this data model. Problemis that Er Studio doesnt directly support outputting to MySQL. Has anyone found a work-around for this? Maybe I can output to SQL meant for another type of DB and then massage the SQL to be appropriate for MySQL? In that case anyone have any idea what DB might be most compatible? Thanks in advance, Tap - 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: ER Studio
From: T. S. Parikh [EMAIL PROTECTED] ...I would like to generate a MySQL DB from this data model. ...Er Studio doesnt directly support outputting to MySQL. This is an interesting topic, IMHO. Tim Bunce has a mysql-to-oracle converter that he mentioned on this list: ARCHIVE: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:81696 I haven't actually looked into what's available, but it might be interesting to have a set of utilities for converting between SQL based schemas. Speaking as a Perl programmer, it might be done by having a standardized token representation of SQL that could be used for explaining a schema. Then have plug-in modules for converting this DB independant information from these representations into DB specific SQL. The usage might look like: use SQL::Tokens::MySQL; use SQL::Tokens::Oracle; $tokenized = SQL::Tokens::Oracle::tokenize($oracle_schema); $mysql_sql = SQL::Tokens::MySQL::generate($tokenized); There would be some obvious problems with things like unsupported data types from one DB to another, not to mention things like FKs, views, etc. --- Rodney Broom Programmer: Desert.Net - 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: ER/Studio
i too am interested, especially for the Mac. pleasepleasepleaseplease At 5:14 PM -0800 1/31/01, David Wilde wrote: Has anyone ever been able to get ER/Studio to work with MySQL? Are there any other database design tools such as ER/Studio that support MySQL directly? Is this a project for sourceforge :) Thanks, Dave W. - 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