Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: jdoran on February 04, 2004, 11:36:04 am

Title: MySQL & DDL generation
Post by: jdoran on February 04, 2004, 11:36:04 am

I'm trying to use EA (3.60.658) to generate some DDL from a data model so I can iniitalize a MySql db(4.0.14).

The MySQL DDL generation in EA is using Innodb for table types that it creates.  No problem with that, but they require that all Foreign Keys are previously INDEXed.   When I add an explicit operation to the problematic table in the EA data model that uses the index stereotype with a particular column, no SQL is generated.   I'm also selecting the Generate Index/Constraints on the Generate DDL dialog.

Has anyone seen this problem or suggest what I might be doing wrong?

Also, is there a way to insert some SQL into the top of the generated DDL file?  I'd like add a "use database" command.

Thanks.

Title: Re: MySQL & DDL generation
Post by: gerolindien on May 17, 2004, 04:51:22 am

Hi,
i'm currently facing exactly the same pb, is it any solution?
(actually only the first and the last index are generated)

Thanks

Title: Re: MySQL & DDL generation
Post by: hd on May 17, 2004, 08:49:32 pm

This is a bug in EA  :-[, and a fix should be available hopefully for build 728.

Title: Re: MySQL & DDL generation
Post by: gerolindien on May 17, 2004, 09:16:40 pm

ok ...  :(
i ll wait then  :P

thx for the quick answer