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

Loss of precision or data

sean.mill@talk21.comsean.mill@talk21.com Posts: 3 New member
edited October 6, 2016 10:37AM in SQL Compare

I got this warning

Severity: High
Object: ABC
Title: Loss of precision or data
This deployment casts the column XYZ on table ABC from [decimal] (2, 2) to [decimal] (18, 2). Any data that exceeds the new column size might lose precision, or the deployment could fail. To avoid this, make sure a migration script covers the change.

This warning is erroneous right? Any data held in the [decimal] (2, 2) column can be contained in the [decimal] (18, 2) column


Sign In or Register to comment.