ER/Studio provides graphical ER diagrams, round trip engineering,
database comparisons (design vs database, design vs design, etc...),
logic and physical database design tools, etc... see
http://www.embarcadero.com/products/Design/erdatasheet.htm
Utilizing only scripts for the link between ER/Studio and Mysql
does not allow a link back from the database back into the graphical design
environment.
Anyway, they do not support mysql as a target database. I tried to use an
ODBC link,
but they first check to see if the link is to a database they support and if
it is
not they kill the process. Anyway I could not get it to work. Guess that
is why they provide
an evaluation.
The good news is with ERwin the database link, round trip engineering, and
all that good
stuff works great now. (This didn't function the last time it tried with
ERwin over a year ago.)
Thanks for your reply!
Roger
----- Original Message -----
From: "Tonci Grgin" <tgrgin@stripped>
To: "Roger Niederland" <rogern@stripped>
Cc: "win32 mysql" <win32@stripped>
Sent: Tuesday, June 27, 2000 2:37 AM
Subject: Re: Data Modeling Settings
> Hi,
> I'm not quite sure I understood You correctly. Here's my opinion:
> Most of the databases use pretty much the same scripts for creating tables
> (ANSI standard). Creating DB's is another question because of advanced
> features every DB has (shadowing, triggers, stored procs...). So as far as
> tables are concerned, just check datatypes and paste query to MySQL.
> What is ERStudio?
> Visit our site and check out my Admin.
> By,
> ----<Tonci Grgin>--<ARTRONIC>----
> <tgrgin@stripped>-<www.artronic.hr>
> ----- Original Message -----
> From: "Roger Niederland" <rogern@stripped>
> To: "Mysql" <win32@stripped>
> Sent: Sunday, June 11, 2000 8:32 AM
> Subject: Data Modeling Settings
>
>
> > We are looking into using ERStudio for graphically entering a data model
> and
> > targeting mysql. The round trip engineering portion of the tool would
> make
> > it easy to convert some of our other DBs to Mysql. ERStudio does not
> target
> > MySQL directly. It supports many DBs and also ODBC links to DBs. What
> > database would most closely resemble MySQL when it comes to CREATE TABLE
> > type scripts? We would like to minimize our effort for messaging the
> output
> > from ERStudio if possible.
> >
> > Thanks,
> > Roger
> >
> >
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
> > posting. To request this thread, e-mail win32-thread2881@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail win32-unsubscribe@stripped instead.
>
