SQL Server 2008 in EA 7.1

[offensiveFeeney]

I have imported the SQL Server 2008 Data Types into our version of EA (7.1)

Made it generate a DDL Package from our DataModel, but the returned SQL is using triggers instead of identity (in create Table) for Auto numbers.

Would love some help with issue.

Thanks in advance

Matt

[Geert Bellekens]

Matt,

Have you tried the same in EA v9?
There have been lots of improvements on the SQL server import and DDL generation.

Geert

[offensiveFeeney]

I haven't tried v9, i could try try the Trial version, but this defeats the object.

Would like to know if it is possible to fix this issue with 7.1.

[Geert Bellekens]

You might be able to edit the code templates for DDL generation, but I'm not sure about that.
If that is not possible, then I wouldn't expect a solution for version 7.1. If Sparx fixes something it is always in the latest version.

Geert

PS. What's holding you back to upgrade to v9?

[Cris Funk]

Has anyone figured out how to modify the code generation templates for the actual database-specific DDL?  I have looked at the DDL transformation templates, but it is my understanding that the tranformation templates are intended for translating one model diagram type to another (ie ERD to Data Model).  I need to be able to extend the output DDL to take advantage to some added tagged values to suppport SQL Server's computed column specification and RowGuid properties.  These would be simple additions to the attribute output when the tagged values are provided.

[smither]

Sorry if this reply is bit tardy.  I asked the same question about customising the Generate DDL function a while back and got this response:

Thank you for your enquiry.

Unfortunately it is not currently possible to customize the generation of DDL beyond the options that are provided on the "Generate DDL"
dialog.

Can you provide examples of the kind of data you wish to model and what your expected output from EA would be?

Best regards,
 
Aaron Bell
Sparx Systems Pty Ltd
[email protected]
http://www.sparxsystems.com

Without the ability to tailor/extend the generator we concluded that EA  was useful only for the 'structural' aspects of physical database design (i.e. tables and columns), and that another mechanism was required for specifying storage options like filegroups, partitioning, compression, encryption, etc.

Not much help, I know...
Eric