numeric data types

Brian Donahue

Hi David,

From having a look at SQL Compare 3.1.7, I can say that the problem is
fixed. If the table doesn't need to be rebuilt, for instance, you haven't
set the 'force column order to be identical' option, SQL Compare will
perform an ALTER TABLE and in that case there is no need to CAST the data to
a new datatype. If the table does need to be rebuilt, SQL Compare still
doesn't use CAST.

Regards,

Brian Donahue
Red Gate Technical Support

"David Johnstone" <david.johnstone@zonal.co.uk> wrote in message
news:rc410wDYEHA.2468@server53...
> Hi,
>
> I'm using SQL Compare 2.02 and have just changed a column from a float to
a
> numeric (10, 2). When SQL Compare scripted the change, the table was
> recreated as numeric(10, 2), but the data from the old table was
transferred
> using cast(OldColumn, numeric). As no precision and scale were specified,
> all the floating point values were rounded to the nearest whole number.
>
> Has this issue been fixed in a later version of SQL Compare?
>
> Thanks,
> David.
>
>