Generate DDL script option

[ameetm]

Hi,

I am using a desktop edition of EA and wanted to know where is the option for " Generating DDL Scripts"?

When i right click on the table the ddl script option is not there  [smiley=sad.gif]

[«Midnight»]

Unfortunately no, not with the Desktop Edition.

This page might be useful: EA Edition Comparison

[Sql Server DBA]

I'm using the corporate edition and the DDL it writes is very, very generic -- as a DBA I'm horrified but I'm sure the architect types think it's grand  

I'd be curious what other DBA's are doing -- there doesn't seem to be a way to set file groups, partions, index fill, or any other tuning option for that matter.  There's a lot more to a database than CREATE TABLE, FK CONSTRAINTS and CK Constraints you know...

[Emilio]

I used to use this on my own sites before but nowadays that the Master of the Data Model function has been vested in me at work I have realized too how HORRIBLE the generated DDL is!!!

We use Microsoft SQL Server 2005 as target database. Now I simply use the model to view but use the MS Management Studio 2005 to design the objects "by hand" based on the UML design.