DDL Transformation

[sgs32r]

Hello,

I wanted to know if it was possible when I make a DDL transformation to specify the database targets.

Thank you for your responses

[«Midnight»]

Do you mean the DBMS that you are working with, or the actual tablespaces (or whatever your product calls them)?

[sgs32r]

Yes, I mean the DBMS that I'm working with.

[«Midnight»]

You can set this at the application level - so that EA will default to a given product. Open the Settings | Database Datatypes dialog. Use the drop-down list at the top to identify your product, then check the Set as Default box.

Of course that does not help you with a project you've already completed.

The database can be set at the package level (I think, but I could be wrong). It can also be set for each table in a data model. For your DDL transforms, I suspect that the setting you want is either the project setting (above), or the package setting.

If you have already transformed to a data model you'll likely have to go through the model and change the setting for each table.

HTH, David

[EDIT: I just remembered that you can also set the default DBMS from the Tools | Options | Source Code Engineering | Code Editors dialog. This is a project-specific setting (now) so you may have to open a project to set the default.]

[Eve]

The built in DDL transformation uses the model default database.

You can also set this from Settings | Database Datatypes | Set as Default, or the code generation toolbar (View | Toolbars | Code Generation)

Of course it is also possible to create duplicate transformations that target different (specific) database targets if that is what you want to do.

[sgs32r]

Thank you for your response and your help