Generating DDL from classes

[David_Travis]

Hi,

I am generating DDL for a SQL Server database from classes. The classes use the VB.NET domain types (eg boolean, string, date).

I have transformed the classes to DDL. Their is no option to specify the destination domain type for the transformation, so the resulting tables  still have the VB.NET domain types (eg boolean, string, date).

For each table I then specify the database as SQL2000 and generate the package DDL.

Unfortunately, the resulting DDL still uses the VB.NET domain types (eg boolean, string, date) rather than the SQL Server domain types (bit, varchar, datetime).

Can anyone tell me how can I use EA (v7) to generate the correct SQLServer DDL?

Thanks
Dave

When I generate the package DDL I spec

[«Midnight»]

I think you will need to do a transform to get the results you want. Take a look at the Code Engineering section of the documentation. Once you get the hang of it, check the Sparx site for white papers and search the forum for a lot of tricks, traps and hints.