question

anjue avatar image
anjue asked

Data migration - precision issue

I am trying to migrate data from QA to Prodution both using SQL Server 2012. I have a table with float column. While migration, I get a warning 'Decimal or Numeric fields on table have different precision, migrating the data may cause overflows'. while Google, I have found to convert the float to decimal or numeric. Is this the only solution? Please let me know how to proceed.
sql server 2012migrationprecisiion
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Why don't schemas in QA and Production match? They should, so decide which precision is 'correct' and make both of them the same. What tool/product are you using to migrate the data?
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
OK so how are you doing the migration?
1 Like 1 ·
anjue avatar image anjue commented ·
The schemas in QA and Production match. They both are float and so I am confused about the error message shown.
0 Likes 0 ·
anjue avatar image anjue commented ·
It was a data issue. Thanks for your quick response.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.