Hi ,

I make upsizing from foxpro in 2009 to SqlServer, and during this date the field was in numeric 10,0 (for a floor an apartement)

Today we want to transform the database in the best quality , and in DDT we put the field Floor in "INT"

Unfortunately, all fields was in numeric, they don't cast in INT with DDT.

I don't know Why, may be DDT does not recognize the type numeric.

Have you an idea to apply the cast ?

thanks
Olivier,

==============================================
Asp.net C# - Strataframe - telerik
==============================================

Trent,

Just a last test, to force the update column, i test the field int to BIGint ,
and i run a deployment => it's ok.

But i change the type from bigint to Int , i have a error : "String or binary data would be truncated"

If i run in TSQL : Alter table [Imhotep].[dbo].[affaires] alter column [etage] [int] not null => it's OK

Do you think ? we could be have a parameters to force the alter column in DDT without stop the process ?

thanks
Olivier

==============================================
Asp.net C# - Strataframe - telerik
==============================================

When are you getting the error?  A BIGINT can't fit into an INT and would in fact be truncated.  I am just trying to understand where you are getting the error.