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