MySQL Question

[amti]

The MySQL database I'm developing uses both InnoDB and MyISAM tables.

I see that the EA docs say to use a different source database for each type.

I'm new to EA, and I want to make sure that it's possible to include both types in one database model before I proceed with setting everything up.

Thanks!

[Bruno.Cossi]

Hi,

you can make each of the tables you design based on a different DBMS, you could even create one table as MySql one, another as Oracle and yet another as Sybase.

Hope this helps!
Bruno

The MySQL database I'm developing uses both InnoDB and MyISAM tables.

I see that the EA docs say to use a different source database for each type.

I'm new to EA, and I want to make sure that it's possible to include both types in one database model before I proceed with setting everything up.

Thanks!

[thomaskilian]

For InnoDB you have to specify a Tag for the table: Type="InnoDB"

[rneelakantan]

I have a similar issue in setting type=InnoDB.  Even after creating Tag (right click on table ->Add ->Add Tagged Value and setting type=InnoDB, I don't see the type set in the generated DDL.  Any suggestion?

[thomaskilian]

Check the case: Type, not type

[rneelakantan]

It worked but not on the first attempt.  I had Type set to InnoDB (capital T in Type).   But it did not work, so I had to delete it, close EA and then open EA and then re-created.  It worked.  

Thx.
Ramanan

[thomaskilian]

Thanks for the feedback