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

Issue comparing field values of type real equal to 0

SQLAdminCJSQLAdminCJ Posts: 17

I am having an issue with the SDK where it is generating diff queries to set real field values equal to 0 that already appear as 0 in both databases (i.e. this field is being registered as different when it is not different).

Perhaps, since the fields are of type real, they contain very small numbers that are appearing as 0 in SQL Server Management Studio?

In any case, how do I avoid having the SDK consider these fields different? Is there a parameter I can set? Please advise. Thanks.


  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for your post.
    We've had issues in the past with FLOATs where a difference is seen due to SQL Data Compare not using the full precision when comparing. We added a comparison option in V10 to use the full precision and it looks like you can utilise this in the SDK too:
    ComparisonOptions.Default | ComparisonOptions.UseFullPrecisionForComparison

    Not sure if this works for REAL though; but it's worth a try...
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.