What are the challenges you face when working across database platforms? Take the survey

numeric data types

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited July 6, 2004 12:51PM in SQL Compare Previous Versions
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.


Brian Donahue
Red Gate Technical Support

"David Johnstone" <david.johnstone@zonal.co.uk> wrote in message
> Hi,
> I'm using SQL Compare 2.02 and have just changed a column from a float to
> 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
> 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.
This discussion has been closed.