Data type from mssql to mysql

[modara]

hi,

I am trying to take data form MSSQL to MYSQL using simple data transfer

my data type is as per following picturehere SQTY is BIG Decimal and Decimal and length is 15 and precesion is 6 for both mssql and mysel

for other column (example: Net_amt, Return_QTY) i dont get any issue when take data from mssql to mysql.

They are same as this SQTY column (BIg Deciman and Deciman lenght 15 and precision 6)

but for this SQTY column i am having issue

in MSSQLi have following value

after data taken from MSSQL to MYSQL same column SQTY

in mysql i have following value

 

please help me out what i should do

[modara]

hi,

I attached a mysql query where sqty before decimal not picking more than 3 digits

but with same Decimal configuration decimal (15,6) it takes 6 digits (example: Net_amt, Sub_total column)

i really need help for this issue. my report showing me incorrect information as this is sale quantity. what i should do please help. here i attached column for understanding.