DDL generation for Sql Server 2005

[sconrad]

Can the DDL generation be modified by the user? I'd like to create DDL for Sql Server 2005. I can create a new database type and create datatypes (to correspond to UDT's), but the generation of DDL is for another database.

If not, can I set this new database type to be based on Sql Server 2000? it seems to be based on something else. Again if not, when will 2005 support be available?

Steve Conrad

[Oliver Michalski]

In the configuration menu under the menu option Database Datatypes you can also put on a new database as product

Oliver

[sconrad]

Oliver,

Thanks. I did that, and was able to add data types to the new product (SQL Server 2005), but the DDL generated was for some other database, and I could not find where the code generation is configured or generated.

My present work-around is to add the UDTs to SQL Server 2000, and that generates the correct code. But I will be missing out on other 2005 features.

Any other thoughts?

[Oliver Michalski]

Hi,

You find the configuration options for code generation (ddl) in the Main Menu under Configuration - Transformation Templates

Oliver