MDA Transformations multiple DDL

[islandvolker]

Hi,

I may be making a general mistake here or I misunderstood something.
What I'm trying to achieve is one design resulting in multiple different databases. What I've done is
1. Created a PIM (class model)
2. Created a view folder under the model root (class view type), called it "output SQLite".
3. Set the default database to SQLite
4. Ran the Transformation of my model, specified the new folder as the target. As expected the result was a new model for a SQLite database. Made a few tweaks here and there.
5. Code Engineerinng-> Generate DDL produced the script code to create the database.

So far all fine. Now I wanted to the exact same thing for e.g. PostgreSQL so I repeated the above from step 2 onwards with a different target folder "output PostgreSQL". Specified that folder as the target and set the default database to PostgreSQL. Inside the PostgreSQL folder a DDL folder is created automatically during the transformation but unfortunately that's all that happens in this folder. The rest of the model transformation goes into the SQLite folder and flattens the previous results (and tweaks).

Is this a bug, by design, am I missing something in here?

Thanks,

IV

[qwerty]

Long time ago, but AFAIR EA links the transformation result source-target with the transformation template. Try to simply copy the DDL transform to one with the DB name inside (e.g. PostgreSQLddl). Then you should be able to run with the original (SQLite) and the PostgreSQL transform into different packages.

q.

[islandvolker]

Needs a bit of fine tuning I suppose but otherwise your suggestion worked like a charm. Thanks very much!

IV