Multiple database DDL support

[nfg]

Hi,

I've been evaluating EA for a little over a day now and it looks more than ample to handle what I can throw at it. What I would like to know however, is if it is possible to model a database schema and generate DDL for it for different databases (MS SQL & PostgreSQL) from the same models?

In the current package I am using, I have to keep two models in sync and this is quite error prone.

Regards.

[thomaskilian]

You could make use of EA's model transformation feature. You have to maintain the PIM and make changes to that. Then you can promote these to different database models.
What is the reason for having two database models?

[hd]

Or you could use the "Reset DBMS Options" feature.

From the package context menu, select Code Engineering | Reset DBMS Options...

[nfg]

Thanks for the suggestions. I will look into them today  

The project I'm working on is EJB based and we have two target platforms for it (Windows/MS SQL Server and Linux/PostgreSQL), hence the need to be able to generate DDL for two different SQL dialects from a single model.