Generate DDL for different databases

[metalmasterx]

Hi *,

we are building a system that supports different databases (MySQL, Oracle, SQL Server).

We'd like to manage the Data Model with EA. Unfortunately, you have to specify the target Database Type per table, so we cannot generate the DDL for all three databases from the same model (which would be nice!).

EA supports generating Database-dependent generation of DDL anyway - why not let the user choose the target database in the "Generate DDL" dialog (which then overrides the per-table setting)?

Best regards,
Egon Schneider

[KP]

Have you had a look at EA's MDA-style transforms? If you start with a platform-independent model, you would need three transformation templates to perform the transform into each of your three chosen platform-specific models (MySQL, Oracle and SQL Server). EA comes with a ready-made generic DDL transformation template which you can modify to suit your needs. Have a look at the help file and come back with any questions that arise...

Neil