How to export datamodel in EA to MySQL database

[shaoyun]

I have modelled the data model including MySQL tables. Can I use EA's tool to transfer the model to MySQL database?

[«Midnight»]

No. Data transfer is meant to transfer a project from one repository to another, or between EAP files and repositories.

You can create the necessary DDL statements to generate your database though, and then execute them in your DBMS to actually perform the build.

First, make absolutely sure that your model elements are set to your target DBMS. Change any that are not. You can set the default DBMS for a project from the main menu via the Settings | Database Datatypes dialog. However, the setting is not retroactive.

Select the package containing the stuff you want to generate - usually a data model - in the Project Browser. From the EA main menu choose Project | Database Engineering | Generate Package DDL. [Be careful you have not selected an individual table in your model, or you'll end up generating the DDL for that table only.]

EA will respond with a dialog offering you several options. Fill these out according to your needs - you will want to play around here to see what happens.

Finally, use the browse button to select a folder and provide a file name, then generate the DDL.

It takes a bit of getting used to, but I've found that once I know the process I can rip through the sequence with very little wasted time.

HTH, David

[shaoyun]

Thanks! Midnight

This is what I need  ;)