Generating DDL

[ms]

Hello,

I would appreciate help with the following questions.

1. How can I generate DDL for MySql?  Currently EA has option for Oracle, MS Access, and SQL Server.  Is there a way that MySql or other database systems (Cloudbase, etc) can be added.

2.  Is it possible to set the database type for the whole project and not just the tables individually.  

3.  Is there a way to define a column that is a foreign key from another table to be the same as the datatype of the foreign key?

4. I have a constraint on a column whose DDL should be as:
 
ADD CONSTRAINT check_parent CHECK (parent in ('Y', 'y', 'N', 'n');

What ever I do in EA all that I get when I generate the DDL is
 ADD CONSTRAINT check_parent CHECK ();


Thanks, and best regards,


-Mohammad

[jaimeglz]

Hi Mohammad,

On 1.: In the menu bar: Reference -> Database Datatypes     click on Add Product  in order to add MySQL. Then, in that same dialog add MySQL datatypes one by one.

But before you do that, let me ask: Are MySQL's datatypes so different from SQL Server's? Testing to see if SQL Server datatypes and code work for MySQL could save a lot of time.

Hope this helps,

Jaime Gonzalez

[Mohammad Salman]

Hi Jamie,

Thanks for your reply.  Well, I thought it would be something more than just the datatype.  I have found that different databases also have different DDLs.  I wish there was some standard DDL.  See, I am trying to get a standard DDL that would work on different kind of databases.  

I did try the SQL Server DDL for Cloudbase  database and it did not work.  Then I thought that if I try for MySql perhaps that would work.

But I would try your suggestion and see how it goes.

Thanks again and best regards,

-Mohammad