Sparx Systems Forum
Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: sgs32r on April 02, 2008, 05:34:24 pm
-
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
-
Do you mean the DBMS that you are working with, or the actual tablespaces (or whatever your product calls them)?
-
Yes, I mean the DBMS that I'm working with.
-
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.]
-
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.
-
Thank you for your response and your help