StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » TEXT / NTEXT data type

TEXT / NTEXT data type

ChanKK — Wed, 10 Jun 2009 06:35:43 GMT

Hi,
I found that DDT doesn't support NTEXT/TEXT data type. May I know why?
I know that it is not recommended to use these data type, however, I really need it as I need to store some process log which would exceed 8K size. Having char field and referring physical path is not preferable in our case.

It is possible to modify the XML generated but it would cause mistake in future.

Please advice. Thank you

RE: TEXT / NTEXT data type

Trent L. Taylor — Wed, 10 Jun 2009 06:35:43 GMT

Actually the DDT does in fact support these types. You have your project set to hide deprecated data types which these fall into that category. Uncheck the Hide Deprecated Data Types flag in the properties of the propfile and they will become available.

Once this is done, you can select these data types.