DDL generation for multiple platforms

[mstier]

Hi!

I'm currently designing a database model for an application which will support multiple RDBMSs (e.g. MSSql, MySQL and Oracle). I wonder how to generate the DDL scripts for those platforms from one model.
What is the best practice?

Best
Markus

[Geert Bellekens]

Markus,

I think you'll need to define MDA transforms for each platform, and then use the standard DDL generation to generate the database.

Geert

[mstier]

Geert,

thanks for this pointer. I found an already existing transformation from a PIM to DDL but there is no option to choose the platform. Isn't this use case so common that there should be an appropriate transformation for the supported platforms?
Do you know how to customize the existing transformation to set a platform? I'm not familiar with transformations (yet).

Best
Markus

[Geert Bellekens]

Markus,

No sorry, I've never used used MDA or code/DDL generation in EA before.

Geert